| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula Help??
I'm creating a huge spreadsheet. This is an example of one of the formulas
that I'm using (=SUMPRODUCT(--(March!$C$3:$C$18="2E"),--(March!$F$3:$F$18="head")). Now since I have a spreadsheet created for each month it is very time consuming to go in and change 30+ formulas so that it is calculating for April, then May, June. Is there a function that I can type in so that the formula will automatically pick up the name of the spreadsheet??? Thank you for you help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| revert formula insertion to old method | Setting up and Configuration of Excel | |||
| Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
Threaded Mode
