- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2008 July
- Formula: What am I Doing Wrong

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.

- Re: Formula: What am I Doing Wrong posted by Bob Phillips on Tue, 15 Jul 2008