Hi All - I feel like this is an easy one, that I should know, but I've been digging into this for over an hour and can't seem to find a formula that will show the sum of how many entries/rows are in a column on a separate tab of a worksheet.
I know I can total it manually, or with the sum function, but this information changes daily and automating it would be helpful.
Thanks in advance for the time and replies.
-George
Try COUNTA
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
What are you trying to sum?
=SUM(Sheet3!F:F)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks