Adding a value of a column based on mutliple arguments

[jono7gold]

Hi

I need to add the value of column C based upon a specific date range in coloumn B and a specific value in column A. Please see example below:


_____A_________B_________C_________D
1__Active_____2/1/14____£123.30____1/1/14
2__ Won______2/1/14____£564.25____31/1/14
3__Won______5/1/14_____£56.23_____Active
4__Active_____6/1/14____£711.22
5__Active_____8/1/14____£107.88
6__Active_____3/2/14____£236.31
7__Active_____8/2/14____£901.60


I would like the foumula to add all the values in column C based upon that column A matches the value in D1 and the date in column B falls between D1 and D2.

So the formula would add cells C1,C4 & C5 from the above table.

Thanks

Jon

[TMS]

Have a look a SUMIFS. Lots of examples around.

Regards, TMS

[Punnam]

hi,

Find the attached workbook which is as per u r requirements .

Punnam

[jono7gold]

Thank you so much, just what I needed.

[Tony Valko]

Try this...

=SUMIFS(C1:C7,A1:A7,D3,B1;B7,">="&D1,B1:B7,"<="&D2)