date counting..

Basically I need to work out, for each financial year, the total spend of all clients.
So looking for something like a count data in column X if date is between 2004 and 2005..

But have no idea how to turn this into an excel formula!

Any help would be greatly appreciated as I've got to the smack-head-against-wall stage and still no further forwards..

Many thanks,

Gem

[QUOTE=Max, Singapore]

Originally Posted by fairy_gemsy

Basically I need to work out, for each financial year, the total spend of all clients.
So looking for something like a count data in column X if date is between 2004 and 2005..

Assuming dates are within A1:A10, amounts within B1:B10

Try something along these lines in say, C1:
=SUMPRODUCT((A1:A10>=--"1-Jan-2004")*(A1:A10<--"1-Jan-2006"),B1:B10)

C1 will return the sum of amounts in col B for which the dates in col A are between 2004 - 2005. Adapt the ranges and criteria to suit.

Thanks Max- will give it a go! xx