how i want to count total for each column based on name and the input is from a different sheet
Best Answer
-
Hi @HZAR - if I understand your question correctly, this can be easily resolved by a simple =COUNTIFS in your target sheet and referencing the source sheet where your input data is, select that column so that it becomes your range and then enter your criterion in double quotes, which in this case might be, "Submit for Approval" or whatever you are trying to count and that would automatically return the result in your target sheet.
Hope this helps!
Cheers,
Ipshita
Ipshita Mukherjee
Answers
-
Hi @HZAR - if I understand your question correctly, this can be easily resolved by a simple =COUNTIFS in your target sheet and referencing the source sheet where your input data is, select that column so that it becomes your range and then enter your criterion in double quotes, which in this case might be, "Submit for Approval" or whatever you are trying to count and that would automatically return the result in your target sheet.
Hope this helps!
Cheers,
Ipshita
Ipshita Mukherjee
-
Hi Ipshita
Thanks for the advise and it helps 👍️I have been missing the double quotes that make my formula is not working
-
Hi @HZAR - I am glad the solution worked. Don't forget to hit the "Awesome" to my response above ;)
Cheers,
Ipshita
Ipshita Mukherjee
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!