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

Meme

=SUMIF(A:A,="GWBK",C:C)

You could use an Advanced Filter to extract the unique PLAN entries to
another cell location.

Then you can use:

=SUMIF(A:A,F1,C:C) assuming that F1 contains, for example, GWBK

Regards

Trevor


"Meme" wrote in message
...
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

Meme,

Another way is to use a Pivot Table which will return something like

GWBK 130
SONR -60
VISC -20
Total 50

HTH
Anders Silven

"Trevor Shuttleworth" skrev i meddelandet
...
Meme

=SUMIF(A:A,="GWBK",C:C)

You could use an Advanced Filter to extract the unique PLAN entries to
another cell location.

Then you can use:

=SUMIF(A:A,F1,C:C) assuming that F1 contains, for example, GWBK

Regards

Trevor


"Meme" wrote in message
...
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