CountIf for Each SubTotal

=COUNTIFS(G:G,"A") would give you the number of times 'A' is listed in column G.
Within a specific sub group in that column would require an extra criteria. You haven't stated what determines the subgroups though.

So if we assume your groups are determing by column F and there are three groups listed in this column (grp1,grp2,grp3) then you can count the number of A's in grp1 by altering the formula to:

=COUNTIFS(G:G,"A",F:F,"grp1")


If this doesn't make sense or provide the solution you are after please provide a small sample file with non sensitive data so that we can better understand your requirements.

Hi there.

A picture is worth 1,000 words. An Excel sheet is worth 1,000 pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet.

Hi. I am baffled. There are no subtotals in your sample. I have no idea what you are trying to achieve...

=COUNTIF(D4:D8,"Match")

will count the number of "Match" values in the range... ????

Can you post another slightly larger sample, with a few subtotals, looking EXACTLY the way they do in your real sheet. Why do you want to use SUBTOTAL in particular? Are the spaces in D4 to D6 of your current sample really present in your real data?

Also, please don't include ANY formulae that are NOT in your real data. i can't see what is your starting point and what is your attempt to get to a solution.

A wild guess. See sheet. Is this anywhere close??

Woo Hoo!!!

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.