sum product or sum if

[GeneJoseph]

A B C D E
1 $100 Yes Matt 5/10/18
2 $200 1/10/18 Jim 5/10/18


Sum A, IF
B = Yes
C= is blank
If B is "yes" and C is blank/ empty, then
D= Matt
E= Month, May (Month=5)

In this instance, the answer would be $100 since A = $100, B= Yes, C is blank, D is Matt and E occurred in May

I think this would be a SUMPRODUCT but looking for solutions

 

[jtakw]

Hi,

Yes, Sumproduct would work.

Substitute "Matt" in the formula to a Cell Reference if you want the formula to be flexible for different names:

Book1
	A	B	C	D	E	F	G
1							Result
2	$100	Yes		Matt	5/10/2018		100
3	$200		1/10/2018	Jim	5/10/2018
Sheet52

Cell Formulas
Range	Formula
G2	=SUMPRODUCT((B2:B3="Yes")*(C2:C3="")*(D2:D3="Matt")*(MONTH(E2:E3)=5)*A2:A3)

 

[GeneJoseph]

Hi,

Yes, Sumproduct would work.

Substitute "Matt" in the formula to a Cell Reference if you want the formula to be flexible for different names:

	A	B	C	D	E	F	G
1							Result
2	$100	Yes		Matt	5/10/2018		100
3	$200		1/10/2018	Jim	5/10/2018

<colgroup><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet52​

Worksheet Formulas Cell Formula G2 =SUMPRODUCT((B2:B3="Yes")*(C2:C3="")*(D2:D3="Matt")*(MONTH(E2:E3)=5)*A2:A3) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

thank you- I will give it a shot!