SUMIF on Cross Sheets

Hello,

I've been trying to create a roll-up based on "Region" from another sheet and I either get "0" or invalid argument.

On inventory sheet I have multiple columns with Budget, Actuals, ect and would like to sumif based on Region. The formula below returns "0"

=SUMIF({Inventory Range 1}, {Inventory Range 2} = "ProServ East")

Any suggestions would be greatly appreciated!

Debbie

Find more posts tagged with

Sheets

Formulas

What is in Ranges 1 and 2?

The basic syntax in your formula will need some tweaking. It should be

=SUMIF(criteria_range, criteria, range_to_sum)

Based on that and some assumptions about your ranges, this may work for you...

=SUMIF({Inventory Range 2}, "ProServ East", {Inventory Range 1})

Paul,

thank you! that worked...

range 2 is the budget column from cross sheet , range 1 is the region column from cross sheet.

Debbie

Ah. Ok. Then the ranges should be swapped with each other in comparison to what I had originally posted.

Glad you got it working.

How to split contents from a cell from a smartsheet into another smartsheet
I need to extract and split the contents of a cell in a Smartsheet into three separate columns to a new smartsheet. The cell entries are originally submitted through a form.
Information in a form populates specific cell.
Hello, Just investigating an idea. I'm building a staff register sheet. I'm curious to know if its possible to populate specific cells by the answers given in a form? So if, in a form, a staff member gives their name, the date and that they will be on leave, sick, training ect. Once the form is submitted, it will populate…
A multiple SUMIF function
My current formula is below. I would like to update this so that I only get a total of those that have been Quoted and have a timeframe data of 2025. How do I add this extra filter into the formula? =SUMIF(Status:Status, "Quoted", [Est. GP]:[Est. GP])