SUMIF only if range is all blanks

[buyshirts]

In column C i have weekly totals in Column E i sum every 4 weeks to give me a monthly totals.
Problem im having is getting Column E to be blank when Column C has 4 blanks.

I'm currently using =SUM(C26:C29) but this is giving me a 0 in Column E which in turns is giving me a false reading on my worst month (because unless i have a value beloew zero its take total's for months that have not happened yet)

I have tried =SUMIF(C26:C29,"<>",C26:C29) but i'm still getting 0 when the cells are blank

ANy help would be much appreicated

 

[FormR]

Hi, SUM() or SUMIF() will always return a number - but you could try something like this to supress the zero's when no cells are populated.

=IF(COUNT(C26:C29),SUM(C26:C29),"")

 

[buyshirts]

Thanks very Much for your help!