Simple solution required!

[krispatterson]

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

	A	B	C	D	E	F
1	DATES	NAMES	NO's	£ VALUES	01/11/16
2					01/12/16

<tbody>
</tbody>

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