Summing multiple values based on cell contents

[NeoFlex]

Hey guys, I'm trying to sum different percentages based on if a cell in the column has text in it. I'm basically trying to see the total email coverage per day based on if that region has text in it.

So D2 should equal 76% (sum of C3:C6) and E2 should equal 77% (sum of C3:C4 + C6:C8).

I have attached a workbook as an example. Any help would be appreciated, thanks! KCCO!

[Ace_XL]

In d2

=SUMIF(D3:D11,"<>"&"",$C$3:$C$11)

Copy across

[Tony Valko]

Try this...

Entered in D2:

=SUMIF(D3:D11,">0",$C$3:$C$11)

Format as Percentage, 0 decimal places.

Copy across as needed.

[NeoFlex]

Thanks guys. This work just as I needed it to.

[Tony Valko]

You're welcome. We appreciate the feedback!