Printing a blank cell if sumproduct formula not true

T

Todd

If I have a formula such as =sumproduct((A1:A5=B2)*
(C1:C5=D2))how can I get the cell that the formula is in
to print blank if the formula is not true? Thanks for any
help.
 
D

Dana DeLouis

...if the formula is not true?

I might be wrong, but it looks to me that you are doing a "Count" of how
many matches there are in Parallel. In Excel, True * True = 1.
Would it be correct to say if the "Count" is zero, then hide the results?
Perhaps a custom format that hides zero values. Say "General;General;", or
something similar. The last ";" will hide zero values.
 
R

RagDyer

One way:

=IF(SUMPRODUCT((A1:A5=B2)*(C1:C5=D2))=0,"",SUMPRODUCT((A1:A5=B2)*(C1:C5=D2))
)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
Top