SUMIFS not working (referencing another sheet)

I'm struggling with getting a SUMIFS function to work properly that is referencing another sheet.

So on my sheet with the function, I have it as:

=SUMIFS({Total GL Detail Range 4}, {Total GL Detail Range 5}, Project8, {Total GL Detail Range 3}, Title@row)

...where the "Total GL Detail" is the other sheet referenced. Range 4 is the column of dollar amounts I'm wanting to summarize, Range 5 is a column of project ID numbers (and the Project8 cell referenced is the location in the current sheet where the specific project ID I want is referenced), and Range 3 is a column of three words ("Revenue", "Cost", and "Margin"...Title@row is the location in the current sheet where the word "Revenue" is referenced). So I'm basically trying to summarize data based on a specific Project ID and for a specific type of dollar (Revenue).

The function just gives me a $0 when the total should be an actual sum of dollars. Any idea where I'm going wrong? (Or if there's a smarter way to do this?) Thank you!

Best Answer

Β«1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!