SumProduct + CountIf

S

Sarah

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$159>0),--($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!
 
P

Peo Sjoblom

Remove the last part

=SUMPRODUCT(--($M$154:$M$159>0),--($L$154:$L$159=N154))
 
Top