| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif function with multiple sheets
That worked great, thank you very much for your help
"Bob Phillips" wrote: =SUMPRODUCT(SUMIF(INDIRECT("'Sheet"&ROW(INDIRECT(" 1:3"))&"'!D8"),101, INDIRECT("'Sheet"&ROW(INDIRECT("1:3"))&"'!M31"))) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "medestar" wrote in message ... Ok, I looked up 3D formula, and as you said, the sumif function is not listed. So how can I work around this ? Any thoughts? "Pete_UK" wrote: Drat !! I forgot about that Bernard - time for some coffee, I think !! <bg Pete On Jun 25, 1:17 am, "Bernard Liengme" wrote: Have a look in Help for "3D formula" SUMIF is not in the list of functions that work with 3D references |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| indirect function within sumif to reference other sheets | Excel Worksheet Functions | |||
| SUMIF with multiple sheets | Excel Discussion (Misc queries) | |||
| sumif across multiple sheets | Excel Worksheet Functions | |||
| SUMIF on multiple sheets | Excel Worksheet Functions | |||
| sumif to add data in multiple sheets | Excel Worksheet Functions | |||
Threaded Mode
