=IF(AND([Yard Location]@row = "Galion", [Pole Size]@row = "35/4")), SUMIF({Pole Count Detail Range 1

LauraZ

Getting an "#UNPARSEABLE" error and cannot figure out what it is. I am trying to sum the pole count for size 35/4 in the Galion Location.

First sheet where we want the formula:

Sheet that we are pulling the data from

Any help is gratefully appreciated. We are a bit new to the functionality of SmartSheet.

Regards,

Laura Zimmerman

Paul Newcome

Try a SUMIFS.

https://help.smartsheet.com/function/sumifs

.

LauraZ

Thank you for the response! I want to verify that the SUMIFS will work with the first spreadsheet have the Yard Location+Pole Size right next to each other, but the second sheet has Location in a column and Pole Size in the top row? In other words, I want the the 2nd report to sum the appropriate column when the Location + Pole Size = Location + Pole Size from the 1st report.

Thank you again for the assistance.

Paul Newcome

Yes. You would use cell references as the "criteria" for each of your ranges.

=SUMIFS({Range To Sum}, {1st Criteria Range}, @cell = [Column Name]@row, {2nd Criteria Range}, @cell = [Column Name]1)

LauraZ

Thank you! Appreciate your help.

Paul Newcome

Happy to help. 👍️