SOLVED

Correcting my formula

Copper Contributor
I am trying to correct my formula.

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

@Mgaspar0426 

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 (Copper Contributor)
Solution

@Mgaspar0426 

Perhaps you mean something like

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

@Mgaspar0426 , you are welcome

1 best response

Accepted Solutions
best response confirmed by Mgaspar0426 (Copper Contributor)
Solution

@Mgaspar0426 

Perhaps you mean something like

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

View solution in original post