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
Result
Yes	Matt
Jim

<colgroup><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]$100 [/TD]

[TD="align: right"][/TD]

[TD="align: right"]5/10/2018[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]$200 [/TD]
[TD="align: right"][/TD]
[TD="align: right"]1/10/2018[/TD]

[TD="align: right"]5/10/2018[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet52​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]G2[/TH]
[TD="align: left"]=SUMPRODUCT((B2:B3="Yes")*(C2:C3="")*(D2:D3="Matt")*(MONTH(E2:E3)=5)*A2:A3)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

thank you- I will give it a shot!