CODEWITHSUNDEEP
google-sheets
Anglers Team
Anglers Team

Reputation: 1

Sum column based on header criteria in google sheets

I want to sum all the quantity sold in all orders here so that sheet will search for Q in column header if its there the sum the below no.

below is a link for my sheet https://docs.google.com/spreadsheets/d/1viATMfTjVHSLrC1HTYKArmJBnrDfeNVj7oSIgdVzLH4/edit?usp=sharing

Upvotes: 0

Views: 1347

Answers (1)

Harun24hr
Harun24hr

Reputation: 37125

You can use SUMPRODUCT().

=SUMPRODUCT((C5:BJ)*(C4:BJ4="Q"))

enter image description here

Upvotes: 1

Related Questions