how can i sum column D of non blank column C depending criteria of column A i have tried sumif but it totaling full column
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
=SUMIF(C1:C17,"<>",D1:D17)
COL A | COL B | COL C | COL D |
AA | TTT | Q1 | 46228 |
AA | TTT | Q2 | 76700 |
AA | TTT | Q3 | 67967 |
AA | TTT | Q4 | 67967 |
AA | TTT | AC | 30443 |
AA | TTT | AG | 606220 |
AA | TTT Total | 895525 | |
AA | TTT Avg | 316068 | |
BB | TTT | Q1 | 46228 |
BB | TTT | Q2 | 76700 |
BB | TTT | Q3 | 67967 |
BB | TTT | Q4 | 67967 |
BB | TTT | AC | 30443 |
BB | TTT | AG | 606220 |
BB | TTT Total | 895525 | |
BB | TTT Avg | 316068 | |
AA | |||
BB |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
=SUMIF(C1:C17,"<>",D1:D17)