Printing a blank cell if sumproduct formula not true

  • Thread starter Thread starter Todd
  • Start date Start date
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.
 
...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.
 
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!
==============================================
 
Back
Top