sumproduct or countif?

Giganews Newsgroups
Subject: sumproduct or countif?
Posted by:  Paul (Msr…@TPx12.com)
Date: Mon, 07 Jul 2008

F    G

4    $34.5
3    $ 23
1    $23
1    $34.5
1    $6.25
2    $23

How do I count the number of instances that are $34.5?  The answer
should be 5  (Row 1= 4 * 34.5, and Row4 =1 * 34.5)

Replies