IF with & to each cells, better way to do?

[chaiyya345]

Hi All,

Reason why i need to use this function is to make total blank if all the selected cells are blank instead of 0 value, imagine if i have >20 cells to be selected, its very manual process, is there better way to do?

I have made a sample to the attachment

eg:

Please Login or Register  to view this content.

Thank-You very much!

[Pete_UK]

You could do it like this:

=IF(COUNTIF(D4:H4,"")=5,"",SUM(D4:H4))

then copy down.

Hope this helps.

Pete

[chaiyya345]

Hi Pete

Yes, it helps. will mark this thread closed & add reputation to you

Thank-You very much!

[Pete_UK]

Glad to help - thanks for the rep.

Pete