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