Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 193
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 287
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 193
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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


All times are GMT +1. The time now is 08:33 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"