I have negative and positive numbers (hours) that I want to sum from several categories on my spread sheet. Each category has a subtotal.
I want to sum both positive and negative hours in one column (start to finish) without including the subtotals. Any help would be much appreciated. Thank-you.
<colgroup><col><col></colgroup><tbody>
</tbody>
I want to sum both positive and negative hours in one column (start to finish) without including the subtotals. Any help would be much appreciated. Thank-you.
<colgroup><col><col></colgroup><tbody> </tbody> | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
=SUMIF(A2:A13,"<0") | negative hours | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
=SUMIF(A2:A13,">0") | positive hours |
<colgroup><col><col></colgroup><tbody>
</tbody>