Forum Discussion

Copper Contributor

Feb 04, 2021

Solved

Correcting my formula

I am trying to correct my formula. I only want it to sum the cells that are associated with the parameters.

Formulas and Functions

SergeiBaklan
Feb 04, 2021
Mgaspar0426

Perhaps you mean something like

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

Diamond Contributor

Feb 04, 2021

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

Mgaspar0426
Copper Contributor
Feb 04, 2021
It will not allow me to attach the picture.

=SUM(Ayden!AR1:OT1, IF(Ayden!AR4:OT4, ">=80"))
- SergeiBaklan
  Diamond Contributor
  Feb 04, 2021
  Mgaspar0426
  
  Perhaps you mean something like
  
  =SUMIFS(Ayden!AR1:OT1, Ayden!AR4:OT4, ">=80")
  - Mgaspar0426
    Copper Contributor
    Feb 04, 2021
    It worked....thanks

Resources