I'd like to use the SUMIFS formula between two tabs.
This function was built using the formula template in Excel, but it returns
an error.

=SUMIFS("='Available Development Hours'!D13:D58","='Available Development
Hours'!A13:A58","Yes")

The same formula does work in the same tab.

=SUMIFS(D13:D58,A13:A58,"Yes")

Will this formula work across tabs?


Thank you for any help that you can offer.