Previous Topic Next Topic

Badly Need Help

Closed
Senaka - 12 Nov 2009 à 10:57
sharpman Posts 1021 Registration date Saturday 23 May 2009 Status Contributor Last seen 20 October 2010 - 16 Nov 2009 à 15:24
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 response

Réponse 1 / 1
sharpman Posts 1021 Registration date Saturday 23 May 2009 Status Contributor Last seen 20 October 2010 183
15 Nov 2009 à 14:28
sorry, confused as to what you want to do
please explain better
senaka
16 Nov 2009 à 11:06
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
sharpman Posts 1021 Registration date Saturday 23 May 2009 Status Contributor Last seen 20 October 2010 183 > senaka
16 Nov 2009 à 15:24
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.

Similar discussions

SD card badly corrupted
HELP -
Ambucias -

1 response