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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!