Badly Need Help

[Closed]
Report
-
Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
-
Hello,

I Need Some Big Help ASAP.... I Need To Know how to get a answer for this


A 1 10
B 2 15
C 3 1000
D 2 25
E 3 75
F 3 54
G 1 5


I Need the Total of 1 ex 15 (10+5)
I Need the Total of 2 ex 40 (15+25)
I Need the Total of 3 ex 1129 (1000+75+54)

Thanks

1 reply

Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
182
sorry, confused as to what you want to do
please explain better
Hey Thanks a lot for replying...

I Need To Know ...

In sheet No 1 we have the following Data


CARS TOYOTA BLACK USD 10.00
CARS NISSAN BLUE USD 20.00
VANS NISSAN WHITE USD 10.00
CARS TOYOTA BLACK EUR 15.00


in Sheet 2

TOYOTA TOYOTA NISSAN NISSAN
BLACK BLACK WHITE BLUE
USD EUR USD USD
CARS
VANS

I NEED TO GET THE TOTOALS OF EACH HOW CAN I
Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
182 > senaka
Ok, i'm assuming that you need the totals on sheet 2

one option would be as follows

if you select all the dat on sheet 2
then create a pivot table, it will create a table so that you can get totals etc.

if you need further assistance please state which version of excel you are using.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!