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.

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…