sumifs formula cross-sheet

Melanie Sanders · 02/09/22

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 · 02/10/22

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

Christina09 · 02/09/22

To understand what's wrong, could you please tell us what is the error message?

Melanie Sanders · 02/10/22

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

Best Answer