Remember Me?

#1
Posted to microsoft.public.excel.misc
 external usenet poster Posts: 193
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.

#2
Posted to microsoft.public.excel.misc
 external usenet poster Posts: 287
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.

#3
Posted to microsoft.public.excel.misc
 external usenet poster Posts: 193
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.

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.

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Dale Excel Discussion (Misc queries) 6 September 30th 07 04:01 PM mshobbs Excel Discussion (Misc queries) 1 September 18th 07 08:29 PM Keith Excel Discussion (Misc queries) 5 August 2nd 07 09:41 PM [email protected] Excel Worksheet Functions 2 April 26th 07 07:12 AM Franz Verga Excel Worksheet Functions 3 June 20th 06 11:53 PM

All times are GMT +1. The time now is 07:24 AM.