sumifs formula cross-sheet

Melanie Sanders

Hi,

I have a partially working formula from a cross-sheet.

=SUMIFS({VENDOR QUESTION Amount of Credit}, {Status}, OR(@cell = "Pending - With AP", @cell = "Pending - With Vendor AP"))

When I try and add in these additional columns, I get an error. {Location # and Name}, LOCATION@row

Any suggestions would be appreciated.

Melanie Sanders

Hi @Christina Lam so today the formula is working.....go figure. Thank you for your offer to assist.