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>
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...