Combining sumif and cross sheet references

CatSusk

Hi,

This is my first time writing a formula of this complexity, and I'd appreciate any help.

In this cell below where it says $500, I want to sum the column labeled Jan 24 in a sheet called 2024 Medicaid Expenses test1, but only when the Label field equals Medicaid-CA-Digital (there are several expenses from different vendors).

I can get the $500 sum for this column, but I'm having a hard time adding the IF statement along with it. My current formula is =SUM({2024 Medicaid Expenses test1 Range 3}).

Or, if you think I should be doing this a different way, feel free to point me in the right direction. I originally tried to make totals in the Expenses sheet, with the thought of linking them, but ran into a circular reference issue.

EvanShortreed

Good Evening,

I am happy to hop on a call to walk you through a solution this week if you're available to fix this issue. Looking forward to your response and assisting.