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
0
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
0
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.
0