Crosssheet Formula

Nat10

Hello,

I am trying to do a cross sheet formula. The formula below is what it looks like in the original sheet and the formula works. Now I want to pull the data from the original sheet into a new sheet and the cross referencing is not working. Any assistance would be greatly appreciated.

Original sheet - works good

=SUMIF(Quarter:Quarter, "Q4'22", [Requested Total]:[Requested Total])

Cross Sheet - not working

=SUMIF({1.AWS MDF Tracker Range 3}, "Q4'22" [Requested Total]:Requested Total])

Thank you

Samuel Mueller

@Nat10 If you are using SUMIF then it should be like this below. First range should be the column that has quarters in it, second is the criteria that matches, and the third would be the range you want to sum.

make sure you didn't grab SUMIFS

When you picked the ranges, you selected the whole column right?

Samuel Mueller

@Nat10 both of your ranges have to be on the same sheet in a formula like that. in your second formula the [requested total] would have to be a cross sheet reference to the same sheet as {1.AWS MDF Tracker Range 3}. Does that make sense?

if not, do you have a screenshot or example?

Nat10

Hi Samuel,

I updated it and still an error - the Range 3 covers the quarter column and range 5 covers the requested total I am trying to sum. I only want to pull the requested amount total for Q4 only.

=SUMIF({1.AWS MDF Tracker Range 3}, {1.AWS MDF Tracker Range 5} "Q4'22")

Samuel Mueller

@Nat10 you need it in the same format as your first formula:

=SUMIF({1.AWS MDF Tracker Range 3}, "Q4'22", {1.AWS MDF Tracker Range 5})

Does that work?

Nat10

I inputted. The error changed to incorrect argument set. So Im assuming elements are correct but the formula arrangement is off?

Samuel Mueller

@Nat10 If you are using SUMIF then it should be like this below. First range should be the column that has quarters in it, second is the criteria that matches, and the third would be the range you want to sum.

make sure you didn't grab SUMIFS

When you picked the ranges, you selected the whole column right?

Nat10

You are a live saver. Thank you that worked. I have some other questions but let me update my trackers on these and then will post again my next set of questions.

Samuel Mueller

Happy to help 😀