On Jun 26, 6:23 pm, James8309 wrote:
On Jun 26, 5:42 pm, Jarek Kujawa wrote:

if you need the number of "Type A" occurences then why not try:

=COUNTIF(A1:A380000,"Type A")

if you need to arrive at a sum of A1:A380000 when there "Type A" in
column B, try:

=SUM(IF(B1:B380000="Type A",A1:A380000,))
CTRL+SHIFT+ENTER it instead of simply using ENTER

I am trying to get a frequency count where Bin array is from
Range("A2:A10")

Thanks for your help

How did you filter in the first place? It sounds like you want SUMIF
with two variables. A SUMPRODUCT might be the easiest way, let your
formula do the filtering.

Otherwise, SUBTOTAL will ignore hidden rows whereas other SUM
functions will not. If you can wrap SUBTOTAL around the IF, it should
work.