Hello Terry,

I don't have access to Excel 2007 right now so this is untested but I don't
think you want those quotes and = signs, try

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

or you could just use an old-fashioned SUMIF:


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



"Terry" wrote:

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.