Multiple If's has got to be easier ....

[shikamikamoomoo]

I need to make a SUM IF based on multiple conditions and just can't seem to get it right....Here is what I need it to do

Add column C1:C100 if A1:A100=2001 AND B1:B100<>"Previous total"

Now I know that is not written in syntax, but that is the problem, I don't know what format to put it in....Please help or point me to where I can figure this out, I tried a few examples but just don't seem to get it right

Thanks,
Jenny

[Domenic]

Try...

=SUMPRODUCT(--(A1:A100=2001),--(B1:B100<>"Previous total"),C1:C100)

or

=SUMPRODUCT(--(A1:A100=D1),--(B1:B100<>E1),C1:C100)

...where D1 contains your first criterion, such as 'Year', and E1 your second criterion, such as 'Previous total'.

Hope this helps!

[shikamikamoomoo]

WOW! Thanks...You just saved me A LOT of time I had the same formula w/out the -- so I guess that makes all the difference... Thanks again