Sum the Column A Only if Column B contains?-CodePudding

I have the table in google-sheets which looks:

I need to sum sums according to the Card = "HDFC"

i.e need to display in cell 1408.8

Need help here.

I Tried:

=COUNTIF(C3:C1000,"HDFC")

but its give count only not sure how to use to get sumif on column B if matches column C

CodePudding user response：

Simple SUMIFS() must work. Try-

=SUMIFS(B4:B,C4:C,E4)

CodePudding user response：

or these:

=SUM(FILTER(B:B; C:C="HDFC"))

=INDEX(QUERY(B:C; "select sum(B) where C = 'HDFC'"); 2)