Software

Ask something
Question Locked

Excel help!!

0 helpful
2 replies

by ashwinigaundan

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
i hav a question? i have a excel database....in 2 sheets i have sum data entered. now how can i write a formular to retrieve all the same entries in sheet 1 and 2 and display it in sheet 3?

2 replies

by pyman51

Copy the sum in sheet 1 and then right click on a cell in sheet 3, select Paste Special and then click on the Paste Link button at the bottom left of the Paste Special Box.

Repeat the above for the total in sheet 2 and drop it in the cell below. Then total the two totals in sheet 3.

Hope the above helps.

This discussion is closed to new replies.