From: embee on 19 Apr 2010 12:13 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.
From: MsExlLearner on 19 Apr 2010 12:20 =SUMPRODUCT((A2:A5="NEW YORK")*(B2:B5="FORD")) Remember to Click Yes, if this post helps!  (MsExlLearner)  "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.
From: Pete_UK on 19 Apr 2010 12:19 Try this: =SUMPRODUCT((A2:A5="new york"),(B2:B5="ford")) Hope this helps. Pete On Apr 19, 5:13 pm, embee <em...(a)discussions.microsoft.com> 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.

Pages: 1 Prev: Help with formula Next: Text from Referenced cell truncated 