Can you use IF statements, Match, Countif etc inside SUMPRODUCT

[Kemidan2014]

I need to graph some data off of a large spreadsheet that we maintain where we use drop down lists to standardize the inputs for example
Product type, Process it was made on, type of defect

I know there's always more than 1 way to skin a cat in excel so I was doing some googling and stumbled across the SUMPRODUCT which I feel might be useful

I was hoping to avoid having to arrange a series of macros to get the data i need for 9 charts by utilizing this sum product function

Is it possible to use SUM PRODUCT and use IF statements or Match to Sum numbers or Count? if so what would that syntax look like, the support website only shows simple math functions

 

[jasonb75]

You can nest anything inside anything as long as it returns the correct type of value for the function.

Without seeing the layout of the source data and some indication of what you want to do with it, examples are near impossible to provide. There are far to many variables to take into consideration which is why the help / support site only shows a few basic examples.

 

[Kemidan2014]

So after alot of Googling and trial and error i found that this formula works

"=SUMPRODUCT((G8:G13="TCC")*(E8:E13="QPR")*(YEAR(F8:F13)=2022)*H8:H13)"

using the following fake table i made

Customer Complaint Tracker.xlsm
	E	F	G	H	I	J
7	Type	Issued	Part type	Defect qty
8	QPR	1/15/2021	TCC	3
9	QIR	2/27/2021	CHC	1
10	QPR	3/14/2022	TCC	27		28
11	QPR	1/14/2022	TCC	1
12	QPR	7/16/2022	PST	1
13	QIR	8/19/2021	PST	1
WM-WS Breakdown

Cell Formulas
Range	Formula
J10	J10	=SUMPRODUCT((G8:G13="TCC")*(E8:E13="QPR")*(YEAR(F8:F13)=2022)*H8:H13)