Multiple Sum If

[stevekho]

Hello Guys,

So here is my probem

I have a table with

A | B | C | D

Start Date | End Date | A Number A | location

.
.
.


I have a month range -> July 2011 and August 2011

I want to sum all the values between this range (Column C) for a specific location.


Thanks for your help!

Steve

 

[cgcamal]

Great you have the solution.

Just in case, some modified option:

Excel Workbook
	A	B	C	D	E	F	G	H
1	Start Date	End Date	A Number A	location	Result		Range to search
2	01-dec-11	29-feb-12	1,161	Loc_A	216816		Begin date	End date
3	01-dec-11	29-feb-12	16,281	Loc_B			01-dec-11	29-feb-12
4	01-dec-11	29-feb-12	27,551	Loc_B
5	01-dec-11	29-feb-12	31,652	Loc_C
6	01-dec-11	29-feb-12	164,544	Loc_B
7	01-jan-12	29-feb-12	8,440	Loc_B
8	01-jan-12	29-feb-12	10,854	Loc_D
...

#VALUE!

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter these manually yourself

Regards.

 

[T. Valko]

Guys it is working now!

Thanks a lot, the formula I posted initially was right but I didnt see that at the end of my table (Row 200), I also had some Loc_A...

Thanks a lot for your time and patience guys. I do really appreciate.

Have a nice Summer!

Good deal. Thanks for the feedback!