Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
I have a table with range name "data",the table is about 500 rows with field name like this : PLAN KEYPRV AMT UNIT ---------------------------- GWBK PVOY 10 2 GWBK VINI 20 5 VISC SV0A 30 3 SONR CSHE -60 4 VISC LOAN -50 2 GWBK TWCU 100 1 My question is how can I get a sum of the AMT by each PLAN? Which sum up function should I use for this purpose? Thanks in advance for inputs. Meme |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Adding a custom function to the default excel function list | Excel Programming |