sumif non blank depending on criteria

[sachin483]

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

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)

 

[AlanY]

try

=SUM(IF($A$2:$A$17="AA",IF(LEN($C$2:$C$17)>0,$D$2:$D$17)))

confirm with shift-control-enter together

 

[Aladin Akyurek]

=SUMIFS(D:D,A:A,"AA",C:C,"?*")

should produce the conditional sum you want.

 

[sachin483]

thanks a lot @Alan Y & @Aladin Akyurek both the formula working fine

 

[AlanY]

thanks a lot @Alan Y & @Aladin Akyurek both the formula working fine

you're welcome
I'm sure you noticed that Aladin's offer is a better/efficient option without the use of array.