Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi all. I've 2 columns (see below)
1 20 3 35 2 10 5 20 4 25 2 30 1 30 I need to get the total for each number on the lefts corrosponding value on the right. ie. Total of 1=50 2=40 etc I tried =IF(D15:D21="1", SUM(F15:F21)) but no joy, can anyone shed some light? thanks and regards gR |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linked Check Boxes | Excel Discussion (Misc queries) | |||
Disable CUT via toolbars or shortcut keys | Excel Discussion (Misc queries) | |||
Disable "Cut" only | Excel Discussion (Misc queries) | |||
Adding the sum of figures in one column if they meet 2 criteria | Excel Worksheet Functions | |||
Adding sales depending on 2 Criteria | Excel Worksheet Functions |