Excel 2007 : How to do Calcs from one worksheet to another.

[jray9242]

I have a spreadsheet that I need to do some calcs for and I need help on how to set it up.

Worksheet: "Main" has the following columns.

Month: Jan, Feb, etc
Amount: ###.##
Code: "Misc", "Cell"
Status: "Good", "Blank"

Worksheet: "Totals" has the following columns.

Code
Totals
Count

I need to do a SUM for each entry like Misc, Cell, etc

I also might need it by Month and Code.

Example

Worksheet1:

Month Amount Code Status
Jan 1.00 MISC Good
Jan 1.00 MISC Good

Feb 1.00 MISC Good

Worksheet2:
Jan MISC 2.00
Feb MISC 1.00

An so on. How can I do this?

Thank you,

Jim

[arthurbr]

Hi and welcome to the board

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!