Crosssheet Formula
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
Best Answer

@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?
Answers

@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?

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")

@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?

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

@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?

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.

Happy to help 😀
Help Article Resources
Categories
Check out the Formula Handbook template!