sumproduct or countif?

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

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)
 
try this that must be array entered using ctrl+shift+enter
=COUNT(IF($O$2:$O$22=34.5,$O$2:$O$22))
 
Thanks for both responses. I saved them. However the following
formula would only work if I reversed it

=SUMIF(F1:F6,34.5,G1:G6)
 
Thanks for the feed-back.

BTW - the formula I suggested matched the example in your OP.
 
Back
Top