Quarterly Budget with SUMIF

Marlayna Sullivan

Good Morning,

I am trying to use the SUMIF function to pull data from another sheet.

=SUMIFS({Budget Requests Range 1}, {Budget Requests Range 2}, "Software", {Q/Y Lookup}, [Q/Y]@row, "")

The other content is:

Budget Amount (Budget Requests Range 1)

Type of Request (Budget Requests Range 2)

Q/Y that the budget applies to (Q/Y Lookup)

Here is the source sheet for awareness (dummy data):

Also, I have helper columns to determine the Quarter and Year based on the Estimated Date of Charge field.

I also tried this formula:

=SUMIF(COLLECT({Budget Requests Range 1}, {Budget Requests Range 2}, "Software", {Q/Y Lookup}, [Q/Y]@row, ""))

Neither of these are working out and I would love a second set of eyes to tell me what I am not seeing.

Jeff Reisman

@Marlayna Sullivan

What is the , "" for at the end of the formula? I'm fairly positive that's causing your incorrect argument set error. Remove the comma and blank quotes and you'll be good!

(And thanks for including screenshots, the formulas you've tried, and the error message!)

Jeff Reisman

@Marlayna Sullivan

What is the , "" for at the end of the formula? I'm fairly positive that's causing your incorrect argument set error. Remove the comma and blank quotes and you'll be good!

(And thanks for including screenshots, the formulas you've tried, and the error message!)

Marlayna Sullivan

@Jeff Reisman I feel so silly! Thank you! I missed that when I copied from another formula I was using, so I didn't have to retype everything.

Thank you! Thank you! Thank you!