# Help With A formula

Options

=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

Options

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")

Options

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")

• Options

FANTASTIC !!!! It worked thank you thank you thank you !!!!!

• Options

HI Andrew

how could i use that same formula but instead give me an average %%

• Options

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!