Hi
this may sound easy but i dunno
I have a spreasheet with multiple pages and i am creating an extra sheet for totals
however
I need a formula that will count the collums with Data in colloum A excluding row 1 as this has headers in Excel 2003
i know how to create a count for a spcific value like yes or john or >9
however colloum as is a sequential list of numbers 1,2,3....... untill the end which may vary from day to day
use =COUNTA()
Hello Cupragsw,
It would be much better if you could upload a small sample Workbook, showing us what you have, and how you would like the outcome to be like.
Regards
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks