Filter then Subtotal

[marshak]

Hi all,

In need of some major help for a report due tonight.

The below calculations fill my table with values based on distinct customer numbers (customer numbers are in column A)

I created column C, because it counts the number of actual entries (that is, a customer number found in in Column A can have multiple entries)


J7 formula:
=COUNTIF(D10:D3000, "$0.00")


K7 formula:
=COUNTIF(F10:F3000, "$0.00")


L7 formula:
=COUNTIF(B10:B3000,"<$0.00")+COUNTIF(B10:B3000,">$0.00")-M7


I now need to be able to see the total of entries in the table. But I cannot figure out how to combine subtotal and countif to produce a value.

I need formulas for cells J8, K8 and L8

For example, The number of customers with only $0.0 is 137. But how many entities? I need a formula that will use the countif formula to filter (=COUNTIF(F10:F3000, "$0.00") AND then subtotal the values found in column G.

I am sorry if this is confusing.

 

[Oscar Cronquist]

For example, The number of customers with only $0.0 is 137. But how many entities? I need a formula that will use the countif formula to filter (=COUNTIF(F10:F3000, "$0.00") AND then subtotal the values found in column G.

Try this:

=SUMIFS(G10:G3000,F10:F3000,"$0.00")

 

[marshak]

Sorry for my late reply. Thank so much for your help! You are awesome!