| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Returning a 0 Value
Hello from Steved
I am getting a 0 value. Ok I have 12 periods I am trying to get this to work for period 2. From Charters "City - Panm" is Cell c27 From Charters "Period 2" is Cell A22 From Charters Cell C33 is the data I require, for worksheet named Kilometres Planned. SUM(IF('From Charters'!$C$1:$C$900="City - Panm",IF('From Charters'!$A$1:$A$900="Period.2",'From Charters'!$C$33:$C$33,0),0)) What Have I not done please. Thankyou |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup returning No data. | Excel Worksheet Functions | |||
| Returning all values from a lookup - not just the first/last one | Excel Worksheet Functions | |||
| Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
| MY VLOOKUP IS RETURNING N/A AND THEREFORE MY TOTAL SUM AT THE BOT. | Excel Discussion (Misc queries) | |||
| returning a text cell based on a number cell | Excel Worksheet Functions | |||
Threaded Mode
