If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
formula similar to "countifs" function in excel 2007
I need a formula similar to the countifs function offered in excel 2007. I'm
using excel 2003 and can't upgrade to 2007. I want to add together cars at a particular location. The location names are in one column and the type of car is in another. In 2007, the formula would be =countifs(a2:a5,"new york", b2:b5,"ford"). What can I do to perform the same function in 2003? Please help. |
#2
|
|||
|
|||
formula similar to "countifs" function in excel 2007
Try this:
=SUMPRODUCT(--(A2:A5="new york"),--(B2:B5="ford")) Hope this helps. Pete On Apr 19, 5:13*pm, embee wrote: I need a formula similar to the countifs function offered in excel 2007. *I'm using excel 2003 and can't upgrade to 2007. *I want to add together cars at a particular location. *The location names are in one column and the type of car is in another. *In 2007, the formula would be =countifs(a2:a5,"new york", b2:b5,"ford"). *What can I do to perform the same function in 2003? *Please help. |
#3
|
|||
|
|||
formula similar to "countifs" function in excel 2007
=SUMPRODUCT((A2:A5="NEW YORK")*(B2:B5="FORD"))
Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "embee" wrote: I need a formula similar to the countifs function offered in excel 2007. I'm using excel 2003 and can't upgrade to 2007. I want to add together cars at a particular location. The location names are in one column and the type of car is in another. In 2007, the formula would be =countifs(a2:a5,"new york", b2:b5,"ford"). What can I do to perform the same function in 2003? Please help. |
Thread Tools | |
Display Modes | |
|
|