HOW TO RUN A ABLE IN EXCEL

[Saumya]

i have a list of items as follows

A B C
1 VEHICLE NO AMOUNT MONTH

2 W 2000 APRIL
3 X 5000 MAY
4 W 6500 APRIL
5 Y 5000 JUNE
6 Z 4600 APRIL
7 W 3500 MAY


NOW I WANT TO ARRANGE THE ABOVE LIST IN TO FOLLOWING FORMAT. THAT IS VEHICLE NO VISE MONTH VISE TOTAL AMOUNTS. PLEASE SHOW ME HOW TO DO THE ABOVE TASK BY USING A FORMULAR. (HOW I CAN FILL THE FOLLOWING BLANKS USING A EXCEL FORMULAR.


REQUIRED FORMAT


VEHICLE NUMBER APRIL MAY JUNE

W ........ ...... .......
X ........ ...... .......
Z ......... ...... .......


THANKYOU.

 

[acw]

Hi

Assuming that your source data is in the range A1:C7 and the output is going into the range F1:I4 then try

=SUMPRODUCT(--($A$2:$A$7=$F2),--($C$2:$C$7=G$1),($B$2:$B$7))

in G2. Copy down / across as required.


Tony