cmillls45

Junior Member

Posts: 5

Quote:

Originally Posted by Spencer101

Depending on which version of Excel you're running, you can do this with SUMPRODUCT or SUMIFS.

Although as you have a worksheet for each month a summary worksheet would make things easier.

Happy to help you set this up if you can provide an example workbook.

I've got 2010. Here's the file, hopefully the attachment worked. I had to do a zip.

Attached Files

Book1.zip (13.3 KB, 165 views)

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sumif and vlookup Help	Nikki	Excel Discussion (Misc queries)	2	June 3rd 10 06:54 PM
Vlookup + sumif , but how????	Jessejames	Excel Worksheet Functions	4	April 21st 10 06:41 PM
sumif/vlookup	Alberta Rose	Excel Programming	1	May 13th 09 01:41 AM
sumif or vlookup help	Katie	Excel Worksheet Functions	2	July 2nd 08 05:21 PM
Vlookup vs Sumif	Steph	Excel Programming	4	July 31st 06 09:32 PM

All times are GMT +1. The time now is 05:38 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us