Return a blank cell

S

Steved

Hello from Steved

=SUMPRODUCT(--($D$2:$D$5000="1-City"),--(TRIM
($C$2:$C$5000)="305"))

Please what is require to the above formula
when the value in a cell is 0 I would like the cell to be
blank.

Thankyou.
 
G

Govind

Hi,

=IF(SUMPRODUCT(--($D$2:$D$5000="1-City"),--(TRIM($C$2:$C$5000)="305"))<>0,
SUMPRODUCT(--($D$2:$D$5000="1-City"),--(TRIM($C$2:$C$5000)="305")),"")

Regards

Govind.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

0 to be blank please 4
Formula please to put a word in the left Cell ( "Roster" ) 3
Is there a more efficient way to write this SUMPRODUCT 4
ignore "0" 9
Formula Issue 2
Don't Display #N/A 1
Corporated into the same fromula please. 5
To leave a blank cell 6

Top