How to count with values from multiple columns?

[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,P272 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

 

[Ashish Mathur]

Confusing question. Please rewrite clearly

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[PF]

Confusing question. Please rewrite clearly

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com


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

 

[Jacob Skaria]

Do you mean..the occurences of 110 where the corresponding cells in M:N range
has a N ?
=SUMPRODUCT((M2:N10="n")*(O210=110))

If this post helps click Yes

 

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

 

[Jacob Skaria]

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(O210,110)

If this post helps click Yes