is this formula will work in smartSHEET?
=SUMIFS([Percentage RFQ]@row, name:name, "Michal Seelbach") / COUNTIFS(name:name, "Michal Seelbach")
hello, is this formula will work in smartsheet? Please help as soon as possible. Thanks
Answers

Try removing the @row from the first argument in your SUMIF and putting
=SUMIFS([Percentage RFQ]:[Percentage RFQ],name:name, "Michal Seelbach")
This will sum all the values from the Percentage RFQ column where the name is Michal Seelbach
=COUNTIFS(name:name, "Michal Seelbach")
This will count how many rows have Michal Seelbach in the name column
=SUMIFS([Percentage RFQ]:[Percentage RFQ],name:name, "Michal Seelbach")/COUNTIFS(name:name, "Michal Seelbach")
This will divide the answer from the Sumif function by the answer to the countif column.
See here for example
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!