Sum ifs

[Notters]

Hi all, i wondered if you could help? please see the example sheet i'm working from

i need to learn/know how to do sumifs, if the criteria for the search is between to points in this case dates.

In A i want to dispaly the value in col B for all that are before a defined date 10/03/2010 (this i can do)

In B i want to display the values of col b that are after the 10/03/2010 but before 10/06/2010

in C want to display the values of col b that are after the 10/06/2010 but before 30/08/2010

Can some one please help

[contaminated]

Try this

=SUMPRODUCT(($A$1:$A$1208>DATE(2010,3,10))*($A$1:$A$1208<=DATE(2010,6,10))*($B$1:$B$1208))

[Notters]

Thank you,

[contaminated]

Would you like to mark your thread as solved if this helped you???

[arthurbr]

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save