| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
|
|||
|
|||
|
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
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 not showing tabs | Excel Discussion (Misc queries) | |||
| Missing worksheet tabs in Excel 2007 | Excel Discussion (Misc queries) | |||
| SUMIFS Formula Problem | Excel Discussion (Misc queries) | |||
| Excel 2007 SUMIFS | Excel Worksheet Functions | |||
| [Excel 2007 Beta2] Function SUMIFS | Excel Worksheet Functions | |||
Linear Mode
