COUNTA: Calculating Dynamically Changing Rows

[gsof]

Hi All,


I am a bit of a newbie to Excel's formulas so apologies in advance for incorrect use of terminology.


However I have an issue that I was wondering if anyone could help me with.


I have a report that varies in row size daily, and I need to count how many employees we have in that one day. So for example one day we may have 50 employees whereas the next day we may only have 4 employees (please see the example I have created).

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Employee Number[/TD]
[TD]Name[/TD]
[TD]Age[/TD]
[TD]Favourite Colour[/TD]
[/TR]
[TR]
[TD][TABLE="width: 122"]
<tbody>[TR]
[TD="width: 122"]gs111[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Gary Smith[/TD]
[TD]10[/TD]
[TD]Red[/TD]
[/TR]
[TR]
[TD][TABLE="width: 122"]
<tbody>[TR]
[TD="width: 122"]as222[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Alan Smith[/TD]
[TD]56[/TD]
[TD]Blue[/TD]
[/TR]
[TR]
[TD][TABLE="width: 122"]
<tbody>[TR]
[TD="width: 122"]bc333[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Barry Corr[/TD]
[TD]23[/TD]
[TD]Red[/TD]
[/TR]
</tbody>[/TABLE]


Currently I am using COUNTA and manually changing this. However I was wondering whether there was a way for the formula to automatically do this so I do not have to keep manually editing the formula daily.


Many thanks in advance.


gsof

 

[gsof]

JackDanIce, Thank you !! That seems to have done the trick perfectly.

I appreciate all of your help and the patience you have had.

 

[gsof]

Apologies for message duplication, had issues with my web browser.

I believe this thread has been solved if the status has to be edited?

 

[JackDanIce]

No worries, good luck with your placement and thanks for the feedback