SUMIFS in excel 2003 1

[Cordeiro82]

Hello All,

I am running Office 2007 and can use SUMIFS to sum all IF statements. However, my collegues are running on 2003 - How do I create a similar statement in excel. I have tried using nested IF's but it did not work.

My SUMIFS statement is here: (SUMIFS('Sheet 1'!A:A,'Sheet 1'!X:X,"5. Decision Reached",'Sheet 1'!AF:AF, "<30"))


Any help would be appreciated.

Thanks.

 

[AnotherHiggins]

[tab][COLOR=blue white]=SumProduct( --('Sheet 1'!X1:X1000 = "5. Decision Reached") * --('Sheet 1'!AF1:AF1000 <30) * ('Sheet 1'!A1:A1000))[/color]

NOTES:
* SumProduct cannot be used with whole-column references, so you'll need to include row references
* Each section of the SumProduct formula must contain the same number of rows

[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]

Did that work for you, Cordeiro82?

[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.

 

[Cordeiro82]

Yes Thanks.