Formaula To CFalculate Total Within Dates

[avendi]

Hi all,

I have attached an example workbook to assist, which has 'Date' in column A, 'Type' in column B and 'Total' in column C. I am looking for a formula that will allow me to calculate the total between two dates, but excluding something in the 'Type' column (B).

Example: Total 1/07/2013 to 31/07/2013, consecutively, excluding Type1 = 8187.

I know this from using the filter, but is there a formula that can do it automatically? I've tried sumifs, sumproduct to no avail.

Cheers, A

[alansidman]

No file has been attached to the thread.

[avendi]

It won't let me uploads my file for some reason. I'll try again.

[avendi]

Hopefully this time...

[FDibbins]

I used this...
=SUMIFS($C$2:$C$3600,$A$2:$A$3600,">="&DATE(2013,7,1),$A$2:$A$3600,"<="&DATE(2013,7,31))
but I came up with 9212

[FDibbins]

deleted forum-induced duplicate thread

[avendi]

Thanks for the reply. 9212 is the total for all within that date range...

[FDibbins]

oops sorry, forgot the last part...
=SUMIFS($C$2:$C$3600,$A$2:$A$3600,">="&DATE(2013,7,1),$A$2:$A$3600,"<="&DATE(2013,7,31),$B$2:$B$3600,"<>type1")
=8187

[avendi]

Thanks very much; great stuff.

[FDibbins]

Happy to help