Excel 2007 - SUMIFS formula use between tabs
 

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.

Excel 2007 - SUMIFS formula use between tabs
 

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.

Excel 2007 - SUMIFS formula use between tabs
 

The SUMIFS formula template stuck the quotes and = signs in there.
Taking them out worked perfectly. Thank you very much.


"daddylonglegs" wrote:

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.