| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to count with values from multiple columns?
Or do you mean?
total number of "N" values from M2:M72,N2:N72 * the total number of occurrences if value =110 =COUNTIF(M2:N10,"N")*COUNTIF(O2:P10,110) If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Do you mean..the occurences of 110 where the corresponding cells in M:N range has a N ? =SUMPRODUCT((M2:N10="n")*(O2:P10=110)) If this post helps click Yes --------------- Jacob Skaria "PF" wrote: 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
