Need help with a formula

Bird_FAT · #1 04-16-2009, 01:11 PM

Oooops

- You're right - COUNTIFS is only for 2007

OK - Lets try a different method:

Code:

=SUMPRODUCT(((Sheet1!A2:A20)="CAIN")*((Sheet1!B2:B20)="TECH"))

and

Code:

=SUMPRODUCT(((Sheet1!A2:A20)="CAIN")*((Sheet1!B2:B20)="PEND"))

Using your sheet (and testing in both 2003 AND 2007) - it all works fine.

Let me know if it's working for you!

tinkertron · #2 04-16-2009, 03:07 PM

It works!!!

Thank you so, so, so, much! You rock!

Can i relay on you for future projects that i might have? Lol

Bird_FAT · #3 04-16-2009, 11:43 PM

Quote:

Originally Posted by tinkertron

Can i relay on you for future projects that i might have? Lol

Sure - I love to practice at every opportunity!

L8R M8!