Formula: What am I Doing Wrong

Giganews Newsgroups
Subject: Formula: What am I Doing Wrong
Posted by:  Paul (Msr…@TPx12.com)
Date: Tue, 15 Jul 2008

4    A
3    A
2    B
1    A

4    $6.00
3    $6.00
2    $2.00
1    $6.00

In the first example I want to know how many instances of A there are
in column B multiplied by the number in Column A.  Answer would be 8.

Formula: sumproduct((a1:a4)*(b1:b4="A"))

But if I want to find out how many instances of $6.00 there are
instead of A, I'm stumped.  I get either 0, or 48.

Must be something simple.

Replies