| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adds City but not Panmure ( Combined Total )
Hello Bob from Steved
I should have my instructions a little clearer. I am adding information from sheet called "1st Week" and it is laid out into seven days, it is put in a summary Sheet Called "City-Panmure Combined". So my question is that if I take either City or Panmure it works as it should ( Singular ), how do I get it to add both City and Panmure. Thanks =IF(ISNA(VLOOKUP({"City","Panmure"},'1st Week'!$A$1:$H$10000,6,0)),"",SUBSTITUTE(TEXT(VLOOK UP({"City","Panmure"},'1st Week'!$A$1:$H$10000,6,0),"#.00"),".",":")*1) Thankyou. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keeping formulas on running total and sorts | Excel Worksheet Functions | |||
| Aling multiple sets of data by header column | Excel Discussion (Misc queries) | |||
| Create List based on cell data | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions | |||
Threaded Mode
