| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
A 13 period exercise
Hello from Steved
In a sheet called summary I have the below formula. 'From Charters'!$B$74=$B$5 is period ie in this case period.4 'From Charters'!$F$17=$A$45 is Charter Kilometres (Other) 'From Charters'!$G$74:$G$74) this is okay if I stipulate G74 Ok my issue is $G$74:$G74 I want it to be $G$1:$G900 Why is because period 5 will be $G$93:$G93, I would like to automate this process =SUMPRODUCT(--('From Charters'!$B$74=$B$5)*--('From Charters'!$F$17=$A$45)*'From Charters'!$G$74:$G$74) Thankyou. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identify month in a period and run a formula | Excel Discussion (Misc queries) | |||
| Huge problem with "if" formula's | Excel Discussion (Misc queries) | |||
| Input period, but get .+ | Excel Discussion (Misc queries) | |||
| Time calculation for a givenn period | Excel Discussion (Misc queries) | |||
| Starting work period on a Saturday and ending on a friday | Excel Worksheet Functions | |||
Threaded Mode
