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")

5 Replies

SergeiBaklan
Diamond Contributor
Feb 04, 2021
Mgaspar0426

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")

Resources