Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count values across multiple columns?
I have the following fields in a spreadsheet:
Order Number Product A Product B I created the following to count the number of orders that had 1 or more of Product A or 1 or more of Product B in them: Count of Prod A: (=COUNTIF(D2:D8611, "0") Count of Prod B: (=COUNTIF(E2:E8611, "0") Now, what I'd like to do is create a column that will display the number of orders that have both Product A and Product B. I've tried this: =(COUNTIF(D2:D8611,"0")+COUNTIF(E2:E8611,"0")) but that gives me the sum of both fields where there is 1 or more product. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Count the occurence of multiple (4 conditions). - Need urgent help | Excel Discussion (Misc queries) | |||
Count on multiple columns | Excel Worksheet Functions | |||
Count occurances of multiple values | Excel Worksheet Functions | |||
Pivot Table combining multiple columns | Excel Discussion (Misc queries) |