Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif
I am trying to sum the data in the Data table as Regions (see Results table),
using the Lookup table to find the region (Lookup Table), without the need to have a lookup column (XX) to Sumif on in the Data Table. Can anyone help please. See below. Lookup Table Data Table Results Table NHU Region NHU Data XX Region Solution a aa a 1 aa aa 63 b bb a 2 aa bb 57 c aa a 3 aa cc 51 d aa b 4 bb dd e bb b 5 bb ee f cc b 6 bb etc c 7 aa c 8 aa c 9 aa d 10 aa d 11 aa d 12 aa e 13 bb e 14 bb e 15 bb f 16 cc f 17 cc f 18 cc |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
SUMIF | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |