Average If

=AVERAGEIF({Project Master Log - COPPERA Range 7}, {Project Master Log - COPPERA Range 6}, "Pending", {Project Master Log - COPPERA Range 2}, Week@row, {Project Master Log - COPPERA Range 4}, Year@row)


I'm trying to average the gpm% of the items that are pending and match the date ranges.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!