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.
Countifs Dynamic ?
-
- NewLounger
- Posts: 19
- Joined: 30 Aug 2023, 20:25
Countifs Dynamic ?
You do not have the required permissions to view the files attached to this post.
-
- Lounger
- Posts: 43
- Joined: 07 Jun 2023, 15:34
Re: Countifs Dynamic ?
i'd try these formulas:
I'd also use Tables instead of normal ranges for the firs list.
I'd also use Tables instead of normal ranges for the firs list.
-
- Administrator
- Posts: 78671
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Countifs Dynamic ?
See the attached version.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- NewLounger
- Posts: 19
- Joined: 30 Aug 2023, 20:25
Re: Countifs Dynamic ?
Thank You Hans.
Exactly what i was looking for.
Exactly what i was looking for.
-
- NewLounger
- Posts: 19
- Joined: 30 Aug 2023, 20:25
Re: Countifs Dynamic ?
could the same thing be done for a total at the end of the table ... =sum(G4:J4)
-
- Administrator
- Posts: 78671
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Countifs Dynamic ?
See the new version.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 818
- Joined: 24 Jan 2010, 15:56
Re: Countifs Dynamic ?
Out of interest why don't you just use:
=UNIQUE(FILTER(B4:B1000,(C4:C1000="ANS"),""))
in F4?
=UNIQUE(FILTER(B4:B1000,(C4:C1000="ANS"),""))
in F4?
Regards,
Rory
Rory
-
- StarLounger
- Posts: 58
- Joined: 10 Mar 2021, 22:57
Re: Countifs Dynamic ?
maybe just Power Query or Pivot Table
You do not have the required permissions to view the files attached to this post.