Correcting my formula

Occasional Contributor
I am trying to correct my formula.

I only want it to sum the cells that are associated with the parameters.
5 Replies


Could you share the formula (better sample file) which you try to correct?

It will not allow me to attach the picture.


=SUM(Ayden!AR1:OT1, IF(Ayden!AR4:OT4, ">=80"))

best response confirmed by Mgaspar0426 (Occasional Contributor)


Perhaps you mean something like

=SUMIFS(Ayden!AR1:OT1, Ayden!AR4:OT4, ">=80")
It worked....thanks

@Mgaspar0426 , you are welcome