Excel 2007 - SUMIFS formula use between tabs

G

Guest

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.
 
G

Guest

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)
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top