Can a sumifs formula pull from data from multiple columns in one row?

Kimberly M

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

Samuel Mueller

What about summing together two sum ifs?

=Sumifs(Range, criteria)+Sumifs(different range, same criteria)

Kimberly M

Thank you Sam, I can try that. Currently my formula looks like this...

=SUMIFS({amount}, {Sum}, [Sum Code]@row, {PCA}, PCA@row)

Samuel Mueller

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

Kimberly M

Hi, yes I was able to get it figured out. Thank you