sumproduct help

[Joneye]

The formula below gives me one answer of 472, what I need to do is ask the formula to also inluced the other fomula that gives me an answer of 99.

How can I construct the formula to add 472 and the 99 together.

=SUMPRODUCT(--($L$7:$L$1126=""),--($F$7:$F$1126=Q1))



=SUMPRODUCT(--($L$7:$L$1126="No"),--($F$7:$F$1126=Q5))

 

[barry houdini]

Probably simplest to just add the two together like this

=SUMPRODUCT(--($L$7:$L$1126=""),--($F$7:$F$1126=Q1))+SUMPRODUCT(--($L$7:$L$1126="No"),--($F$7:$F$1126=Q5)) <!-- / message --><!-- sig -->

 

[Joneye]

Yes thats the GEM...

Thanks