is this formula will work in smartSHEET?

kumars23

=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

Debbie Sawyer

@kumars23

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