Calculating between 2 worksheets

[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

 

[VoG]

Maybe

=SUMPRODUCT(--(Sheet1!A1:A100=A1),--(Sheet1!C1:C100="MISC"),--(Sheet1!C1:C100="GOOD"),Sheet1!C=B1:B100)

Or maybe a Pivot Table.

 

[jray9242]

Thank you, I will try this and let you know how it goes.

Jim

 

[jray9242]

This did work so I have simplified my question in a new thread.

Thanks,

Jim

 

[Joe4]

If it did work, why did you re-post the question in another thread?

If it did not work, please keep re-posting in this thread. Do not start a new thread, as threads of a duplicate nature will be locked or deleted per forum rules.

 

[jray9242]

http://www.mrexcel.com/forum/member.php?u=6721Joe4,

Sorry for the mistake. What I meant to say was that it didn't work for me so I simplified the question to make it clearer.

Jim

 

[Joe4]

The simplification should be posted back to the original thread. Per forum rules, posts of a duplicate nature will typically be deleted or locked (see rules #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).

 

[jray9242]

Understood and will keep that in mind next time.

Thank you,

Jim