SumProduct + CountIf
 

Hi there,

I'm using a sumproduct formula to add data from 1 column, based on 2
conditional colums. So my formula looks like this:

=SUMPRODUCT(--($M$154:$M$1590),--($L$154:$L$159=N154),$M$154:$M$159)

I actually want to count the numbers in column M, not add them. How do I
build the countif functionality into the sumproduct?

Thanks!

SumProduct + CountIf
 

Remove the last part

=SUMPRODUCT(--($M$154:$M$1590),--($L$154:$L$159=N154))


--
Regards,

Peo Sjoblom



"Sarah" wrote in message
...
Hi there,

I'm using a sumproduct formula to add data from 1 column, based on 2
conditional colums. So my formula looks like this:

=SUMPRODUCT(--($M$154:$M$1590),--($L$154:$L$159=N154),$M$154:$M$159)

I actually want to count the numbers in column M, not add them. How do I
build the countif functionality into the sumproduct?

Thanks!

SumProduct + CountIf
 

The simple answers are the most embarrassing - thanks!

"Peo Sjoblom" wrote:

Remove the last part

=SUMPRODUCT(--($M$154:$M$1590),--($L$154:$L$159=N154))


--
Regards,

Peo Sjoblom



"Sarah" wrote in message
...
Hi there,

I'm using a sumproduct formula to add data from 1 column, based on 2
conditional colums. So my formula looks like this:

=SUMPRODUCT(--($M$154:$M$1590),--($L$154:$L$159=N154),$M$154:$M$159)

I actually want to count the numbers in column M, not add them. How do I
build the countif functionality into the sumproduct?

Thanks!