Can a sumifs formula pull from data from multiple columns in one row?
Options
Newbie here, trying to get my budget summary sheet to pull data from budget tracking sheet. Currently using a sumifs formula, working fine, however I need to also have it recognize additional columns and I am struggling to set up the formula correctly. Is this something that can be done? Thank you
Answers

What about summing together two sum ifs?
=Sumifs(Range, criteria)+Sumifs(different range, same criteria)

Thank you Sam, I can try that. Currently my formula looks like this...
=SUMIFS({amount}, {Sum}, [Sum Code]@row, {PCA}, PCA@row)

@Kimberly M did you figure this out? are you trying to sum two different ranges?

Hi, yes I was able to get it figured out. Thank you
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!