| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUM a row of data and then use VLOOKUP to paste the total valueinto another worksheet
On Apr 29, 11:55*am, "Mike Fogleman" wrote:
Why VLookup? Why not SUM. VLookup needs three arguments, where are they located? Mike wrote in message ... Hi, I have a row of 5 values. The sum of the 5 need to be put into another worksheet using the VLOOKUP function. Does anyone know how to do this? Thanks.- Hide quoted text - - Show quoted text - ah, because my manager doesn;t want the total (sum) to appear on the first sheet, he only want it on the second sheet which is why I need a formulae which will both do a SUM calculation and a VLOOKUP (if necessary) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy sub total data only onto a new worksheet? | Excel Discussion (Misc queries) | |||
| Copy data from one worksheet and paste into another worksheet | Excel Programming | |||
| How to get month wise total of a worksheet having a years data? | Excel Discussion (Misc queries) | |||
| Paste data from another worksheet | Excel Worksheet Functions | |||
| Filtered Rows / Numeric Data - Automate Position of Total on Worksheet | Excel Programming | |||
Threaded Mode
