|
|
#1
04-19-2017, 04:10 AM
|
|||
|
|||
If column A contains X and Column B contains Y then total how many
Hi,
I am looking for some help please. I have rows of data on a excel sheet and i am looking to total these up using formulas. I would like to know how many Red Cars that are 5 door there are and in the 3rd colum put the total count. For example. Red 5 Blue 2 Red 5 Red 5 Green 2 Then the answer in my other box would be 3 can you tell me if this is possible please thank you 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Read multiple xml files in excel - Column names and Tag - Column alignment | sumshen | Excel Programming | 0 | 04-17-2017 12:55 AM |
 Query total column
|
Forums10 | Office | 1 | 06-07-2015 04:08 AM |
|
How to obtain a column total using only specific cells
|
Jo Freeman | Excel | 3 | 03-20-2015 06:18 AM |
| How can I temporarily break a 3 column format in order to type a single column paragraph | William P | Word | 1 | 01-04-2015 06:40 PM |
| Want a quotient using a constant to show up in column c each time a number is added to column b | fibbermcghee | Excel | 2 | 12-09-2014 05:48 PM |
Windows 8 
Office 2007
Threaded Mode