| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
SUMPRODUCT across worksheets
I am familiar with using SUMPRODUCT(--(criterion=range1),(range2)) to obtain
results not possible with SUMIF. However, I would now like to apply this to, say, all D5 cells in many contiguous worksheets. I get error results. Can someone confirm that this is not possible to do? Any suggestions for a way around this? Many thanks, Stephen Powell |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of worksheets | Excel Discussion (Misc queries) | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
| Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
| Sort/Link Worksheets | Excel Worksheet Functions | |||
Threaded Mode
