sum if

inon rettig

hi

i am making a cross reference sheet. in one cell i want a sum of "quote for client" column if "approved" column says "yes"

BullandKhmer

=SUMIFS({Reference 'Quote for Client' Column},{Reference 'Approved' Cloumn},"YES")

inon rettig

thanks

i already solved myself

now i am trying to sumifs from multiple sheets

i wrote:

=SUMIFS({2022 - Material 01-JAN Range 5}, {2022 - Material 01-JAN Range 4}, 1) + SUMIFS({2022 - Material 01-JAN Range 1}, {2022 - Material 01-JAN Range 2}, 1)

didn't work

https://community.smartsheet.com/discussion/comment/318846#Comment_318846