| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to count with values from multiple columns?
Confusing question. Please rewrite clearly
-- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "PF" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to count with values from multiple columns?
"Ashish Mathur" wrote: Confusing question. Please rewrite clearly -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "PF" wrote in message ... 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 OK, how about this Columns M and N contain values N or Y (received yes or no) Columns O and P contain values 110, 120, 125 etc (ski pole length) I want take total of all "N" values from columns M and N times the total occurrences of 110 in columns O and P. Sum would be in Q1 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to count with values from multiple columns?
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to count with values from multiple columns?
If this was your data:
N...N...110...110 Y...N...110...110 N...Y...120...110 Y...N...110...120 What result do you expect? -- Biff Microsoft Excel MVP "PF" wrote in message ... "Ashish Mathur" wrote: Confusing question. Please rewrite clearly -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "PF" wrote in message ... 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 OK, how about this Columns M and N contain values N or Y (received yes or no) Columns O and P contain values 110, 120, 125 etc (ski pole length) I want take total of all "N" values from columns M and N times the total occurrences of 110 in columns O and P. Sum would be in Q1 |
|
#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 |
| Reply |
| 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 | |||
Linear Mode
