Thanks Very much (and noted the comment about different sized ranges). Is
there actually a way of doing the dates within the formula something like
this..

SUMIF('Costs detail'!$Q$2:$Q518,Date1,2,2008,Date<30,4,2008,'C osts
detail'!$O$2:$O$542)...ie so that within the formula I list the date before
and after that I want to apply?

Thanks


"T. Valko" wrote:

One way...

A8 = start date = 2/1/2008
A9 = end date = 4/30/2008

=SUMIF('Costs detail'!$Q$2:$Q518,"="&A8,'Costs
detail'!$O$2:$O$518)-=SUMIF('Costs detail'!$Q$2:$Q518,""&A9,'Costs
detail'!$O$2:$O$518)

Note that in your posted formula you have different sized ranges:

$Q$2:$Q518
$O$2:$O$542



--
Biff
Microsoft Excel MVP


"spudsnruf" wrote in message
...
Hello

I would like to learn how to calculate amonts in a sumif that are between
2
dates.

eg =SUMIF('Costs detail'!$Q$2:$Q518,A8,'Costs detail'!$O$2:$O$542)
.....where A8 is currently just a month reference (I mean it looks at cell
A8
where I type in the month). So in other words, I'd like it to look up
values
in another worksheet called Costs Detail, providing the associated dates
are
between, say 1st Feb and end of April. Any help always please.