Countifs Dynamic ?

[hemrajrav328]

Is there a way for the formulas in G, H, I & J to automatically copy down as data gets added to the table (B:D)
Similar to how the Filter function works.

[robertocm]

i'd try these formulas:

Countifs.xlsx

I'd also use Tables instead of normal ranges for the firs list.

[HansV]

See the attached version.

Countifs.xlsx

[hemrajrav328]

Thank You Hans.

Exactly what i was looking for.

[hemrajrav328]

could the same thing be done for a total at the end of the table ... =sum(G4:J4)

[HansV]

See the new version.

Countifs.xlsx

[rory]

Out of interest why don't you just use:
=UNIQUE(FILTER(B4:B1000,(C4:C1000="ANS"),""))
in F4?

[hamster]

maybe just Power Query or Pivot Table