Prev: Help with formula
Next: Text from Referenced cell truncated
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: Ms-Exl-Learner on 19 Apr 2010 12:20
=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.
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