How to find the total result of selected category?

Question

Im here with a query that in my sheet, I want to find the total sales of a selected category. for eg in that sheet if we select Audi and Feb from the dropdown list the H4 column must display the total sales happened for Audi in FEB month. please take a look to my sheet so that you will get clear what i want to say.

https://docs.google.com/spreadsheets/d/1Ec6tNevF5e3UF_AMFSUHgmlWwVibsEc6uMEGNDCKopQ/edit?usp=sharing

Thanks in advance

https://docs.google.com/spreadsheets/d/1Ec6tNevF5e3UF_AMFSUHgmlWwVibsEc6uMEGNDCKopQ/edit?usp=sharing

Thanks in advance

user_5632629 · Answer

use:

=IFERROR(SUM(INDEX(QUERY({D7:G}, "where 1=1 and "&
 TEXTJOIN(" and ", 1, 
 IF(D4="",,"Col1 = '"&D4&"'"),
 IF(E4="",,"Col2 = '"&E4&"'"),
 IF(F4="",,"Col3 = '"&F4&"'"))),,4)), 0)

user_1683034 · Answer

change from Sumif to Sumifs! Look at your sheet :D for reference i put the new syntax here =sumifs(G7:G14, F7:F14, $F$4, E7:E14, $E$4)

cheers

How to find the total result of selected category?

2 Answers