Hello,
I'm trying to add a =COUNTA() function to the bottom of multiple groups of rows with a varying number of rows within each group. I would like the formulas to populate in the row directly below each group of rows (i.e. row 5).
Hello,
I'm trying to add a =COUNTA() function to the bottom of multiple groups of rows with a varying number of rows within each group. I would like the formulas to populate in the row directly below each group of rows (i.e. row 5).
Something like C5 = Counta(C2:C4)the formulas to populate in the row directly below each group of rows
What is the issue ?
Why not a sample Excel file for example !!!
- Battle without fear gives no glory - Just try
Give this macro a try...
![]()
Please Login or Register to view this content.
This looks to be working perfectly. Thank you!!
Hi, assuming that your data come like in the picture, you only need a pivot table
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks