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]

Ah thanks JackDanIce! I will read the website again I must have misread it.

I appreciate your help and again sorry for my slowness I'm on a placement at work and this is the first time I have had to use such features in Excel, so in Excel terms I guess I am still a baby haha.

 

[vigneshravindran]

hiii select the entire range i mean the column here and apply the formula

 

[vigneshravindran]

select the entire range and apply the formula in some other cell ...

 

[Aladin Akyurek]

Thanks Aladin Akyurek,

Apologies I have tried your example and it is not returning back the number of employees in my practice table :\
in using =COUNTIF(EMPLOYEES,"?*") it is returning back #VALUE!

If the employee numbers consist of entries like gs111 (thus text) and you have defined EMPLOYEES as stipulated, the suggested COUNTIF formula should invariably yield the number of employees you have.

 

[gsof]

Ah thanks JackDanIce! I will read the website again I must have misread it.

I appreciate your help and again sorry for my slowness I'm on a placement at work and this is the first time I have had to use such features in Excel, so in Excel terms I guess I am still a baby haha.

 

[vigneshravindran]

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

select th entire range and do use the formula in some other cell

 

[gsof]

Thank you JackDanIce

I believe I have got it working.

Again thank you all for your patience with this

 

[gsof]

Thank you JackDanIce

I believe I have got it working.

Again thank you all for your patience with this

 

[gsof]

.

 

[gsof]

Thank you JackDanIce

I believe I have got it working.

Again thank you all for your patience with this