SumProduct + CountIf

[Guest]

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!

 

[Peo Sjoblom]

Remove the last part

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

 

[Guest]

The simple answers are the most embarrassing - thanks!