Feb 04 2021 06:48 AM - edited Feb 04 2021 06:49 AM
Feb 04 2021 06:54 AM
Could you share the formula (better sample file) which you try to correct?
Feb 04 2021 07:07 AM - edited Feb 04 2021 07:12 AM
It will not allow me to attach the picture.
=SUM(Ayden!AR1:OT1, IF(Ayden!AR4:OT4, ">=80"))
Feb 04 2021 08:19 AM
SolutionFeb 04 2021 08:19 AM
SolutionPerhaps you mean something like
=SUMIFS(Ayden!AR1:OT1, Ayden!AR4:OT4, ">=80")