| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to count with values from multiple columns?
I want to take the total number of "N" values from M2:M72,N2:N72 * the total
number of occurrences if value =110 (or 120,125 etc)in O2:O72,P2:P72 I also need the count to adjust as the "n" is changed. I've tried SUMPRODUCT, COUNTIF, IF and various combination's but I still can't get what I'm after. Any help would be much appreciated. Patrick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count unique values across two columns with multiple conditions | Excel Worksheet Functions | |||
| Filter Multiple Columns on Multiple Criteria and count the last co | Excel Worksheet Functions | |||
| To count the data using multiple criteria in multiple columns | New Users to Excel | |||
| How do I count values across multiple columns? | Excel Worksheet Functions | |||
| How to Count Rows with defined values in multiple columns | Excel Worksheet Functions | |||
Threaded Mode
