Simple solution required!

[krispatterson]

Another basic one for you guys (I hope!).


[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]DATES[/TD]
[TD]NAMES[/TD]
[TD]NO's[/TD]
[TD]£ VALUES[/TD]
[TD]01/11/16[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]01/12/16[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


I need a formula that looks at:
> column A, and searches for all dates with a month of date stated in Column E
> column B, and searches for a specific name
> column C, and searches for a range of numbers
> column D, and adds up the values that fit in the above criteria


So, result in F1 would be the total value of the values in D based on the number of instances of a date in Nov 16, where the name in 'B' is "Chris" and where the number in 'C' is either "1", "2" or "3".


I've used SUM, COUNTIF & SUMPRODUCT before but can't figure out which is best for this...

Let me know guys, thanks in advance :D

 

[FormR]

Hi, sounds like you want a SUMIFS()

For example:

=SUMIFS(D:D,A:A,">="&E2,A:A,"<"&E3,B:B,"Chris",C:C,">=1",C:C,"<=3")

 

[krispatterson]

Hi, sounds like you want a SUMIFS()

For example:

=SUMIFS(D:D,A:A,">="&E2,A:A,"<"&E3,B:B,"Chris",C:C,">=1",C:C,"<=3")

Thanks FormR