| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF with multiple sheets
Sorry, I only tested with 2 sheets, hence C1 and C2. As Peo says, you should
list all the target sheets in C1:Cn, and adjust the formula to suit. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "frustratedwthis" wrote in message ... I tried the formula and it returns REF. Any other suggestions? and THANKS for you r help!! "Bob Phillips" wrote: =SUMPRODUCT(SUMIF(INDIRECT("'"&C1:C2&"'!I6"),"NP", INDIRECT("'"&C1:C2&"'!I8") )) where C1:C2 is a range housing the relevant sheetnames in separate cells. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "frustratedwthis" wrote in message ... I am trying to use the following formula to sum the same cell on multiple sheets IF the critria in another cell on each sheet matches : =SUMIF('06-01:06-92'I6,NP,'06-01:06-92I8) I get a return of VALUE. Can I not use SUMIF to calculate the numbers I need? Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| selecting multiple sheets | Excel Worksheet Functions | |||
| Printing Multiple sheets | Excel Discussion (Misc queries) | |||
| How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions | |||
| Can I unhide multiple sheets at once? | Excel Discussion (Misc queries) | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
