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

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

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

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

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

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