Live Tally Counter from other sheets

[JJW1996]

Hey all!

Incredible long shot here, just wanted to make sure if it's actually possible or not..

At my current workplace, we have a lot of live web-excel sheets, however I'm creating a sheet which has buttons & hyperlinks to those sheets - essentially making a hub for my colleagues so they can find sheets more easily.

At the moment, I'm trying to create a live tally counter which feeds back how many columns are on one of those live sheets. So for example, let's say I have a live sheet called 'Stock count' and there are 5 columns on that sheet which colleagues can add at any time, I would like to have the number "5" under a title saying "Live Stock Level" on the main hyperlink sheet - but for it to update to let's say 6 if a colleague adds another column.

Is this possible? Maybe I'm thinking excel can do a little too much!

Thank you!!

 

[Candyman8019]

You could use a formula such as the following:
=COUNTA('[OtherSheetName.xlsm]TabName'!$A$1:$BH$1)

This will count the number of columns in Row1 that are not blank...up to 60. If there is a potential for more columns than that then change $BH$1 to $BZ$1 or whatever range is relevant for your needs.

 

[JJW1996]

You could use a formula such as the following:
=COUNTA('[OtherSheetName.xlsm]TabName'!$A$1:$BH$1)

This will count the number of columns in Row1 that are not blank...up to 60. If there is a potential for more columns than that then change $BH$1 to $BZ$1 or whatever range is relevant for your needs.

Hey, thanks for your response.

Maybe my mistake in the question but I need this to count downwards rather than sideways, I have tried to replace 'COUNTA' with 'COLUMNS' but it's always showing at 60, even though there is only 40 on the sheet. Do you know how I could do this please?

Appreciate your help so far!

 

[Candyman8019]

If you need it to count rows then simply change the range from A1:BH1 to A1:A100 for example