Help With A formula
=SUMIF({Quality Checks Tracker FY21-22 Range 1}, IF({Quality Checks Tracker FY21-22 Range 2}, [Primary Column]@row))
I am trying a formulas that will count that numbers in the right hand column if/when the description on the right hand side is the same eg so i want a total for full inspections - this needs to be linked to another sheet that will tell me the quantity count of full inspections and visual inspections ect ect
Best Answer
-
Try using =SUMIFS as the logic, something like this:
=SUMIFS({Quality Checks Tracker FY21-22 Range 1},{Quality Checks Tracker FY21-22 Range 2}, [Primary Column]@row)
or in a new report, define the ranges and use (for example)
Qualcheck1 for Quality Checks Tracker FY21-22 Range1, etc
=SUMIFS({Qualcheck}1, Task@row, {Qualcheck2}, "July")
Answers
-
Try using =SUMIFS as the logic, something like this:
=SUMIFS({Quality Checks Tracker FY21-22 Range 1},{Quality Checks Tracker FY21-22 Range 2}, [Primary Column]@row)
or in a new report, define the ranges and use (for example)
Qualcheck1 for Quality Checks Tracker FY21-22 Range1, etc
=SUMIFS({Qualcheck}1, Task@row, {Qualcheck2}, "July")
-
FANTASTIC !!!! It worked thank you thank you thank you !!!!!
-
HI Andrew
how could i use that same formula but instead give me an average %%
-
Good question, I haven't personally used that in smartsheet as yet, in Excel I use =AVERAGEIF
I found this, hope it helps - https://help.smartsheet.com/function/averageif?frame=0&nav=1
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!