| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
do i use vlookup or sumproduct???
I have these two sheets (as an example)
Sheet 1 : ..........A................ B........... C .........D ......Product .........Total ......Codes ..........sales 3 ..apples 4..pears 5 ..bananas Sheet 2: ..............s...................t.............. u ...............v .............Product... Sales .............Codes 48 ......apples........ 20 49...... pears .........15 50..... bananas...... 23 51 ......apples .........8 52 .....apples .........13 53 ...bananas .........15 In column b on sheet 1, i wish to total the sales values - so for example column b 3 i wish to add up ALL the sales of apples (20+8+13 =answer 41).... What formula do i need to put in column b3 to achieve this? many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct and Vlookup | Excel Discussion (Misc queries) | |||
| Which SumProduct Sumif or VLookup? | Excel Discussion (Misc queries) | |||
| VLOOKUP in SUMPRODUCT array | Excel Worksheet Functions | |||
| I've tried Sumproduct, SumIf, Vlookup and Hlookup. | Excel Worksheet Functions | |||
| Sumproduct with a vLookup, multiple criteria | Excel Worksheet Functions | |||
Threaded Mode
