How to count with values from multiple columns?

P

PF

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
 
P

PF

Ashish Mathur said:
Confusing question. Please rewrite clearly

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com


OK, how about this
Click to expand...
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
 
J

Jacob Skaria

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
 
T

T. Valko

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?
 
J

Jacob Skaria

Or do you mean?
total number of "N" values from M2:M72,N2:N72 *
the total number of occurrences if value =110
Click to expand...

=COUNTIF(M2:N10,"N")*COUNTIF(O2:p10,110)

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need a function to fill column from other columns 5
How to combine SUMPRODUCT with COUNTIF? 7
Using SUMPRODUCT to count values in separate columns 4
How to count occurrences where 2 columns are required to be true? 1
Count Unique Values with Multiple Criteria 3
Using CountIF with multiple conditions 9
Combining Data from Multiple Columns 2
how can i count multiple variables in multiple columns? 1

Top