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).

Employee Number	Name	Age	Favourite Colour
gs111 <tbody> </tbody>	Gary Smith	10	Red
as222 <tbody> </tbody>	Alan Smith	56	Blue
bc333 <tbody> </tbody>	Barry Corr	23	Red

<tbody>
</tbody>

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