sum cells based on multiple conditions

[dr772]

Spreadsheet
Date Unit Minutes
1/1/08 2M 40
2/5/08 4M 15
2/7 5M 10

I tried but is doesn't use the conditions I put in, it just gives me a total of 65.
FORMULA:
SUM(IF((Data!$A$2:$A$8000>VALUE("12/31/2007"))*(Data!$A$2:$A$8000<("2/1/2008")),Data!$C$2:$C$8000))

Please help

 

[AnotherHiggins]

=SumProduct((Data!$A$2:$A$8000>VALUE("12/31/2007")) * (Data!$A$2:$A$8000<VALUE("2/1/2008")) * (Data!$C$2:$C$8000))

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[dr772]

thanks, I tried the sumproduct but I must have done somthing wrong....when i copied and pasted yours, it works...GREAT..

 

[AnotherHiggins]

Sorry - got pulled away and pressed submit before writing any explanation.

You used "Sum[highlight]([/highlight]IF...". SumIf is a separate function. But it only accepts one condition.

For multiple conditions, you can use SumProduct, as I did above. I also added the "Value" around the second date condition.

Consider using two cells to store your start and end dates. That will make it easier to change the criteria.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[AnotherHiggins]

I didn't see your post before submitting my last.

Glad to help.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[dr772]

THANKS AGAIN....