Help needed for sum / range calculation from one worksheet to another

ballst · #1 07-06-2015, 11:20 AM

Hi all,

My excel 2003 in easy steps book didn't have the answer for this one and my web search didn't throw up anything similar, I have tried to modify what I have tracked down, but without success, hence my post.

I'm therefore looking for some help with a sum which calculates data from one worksheet, but displays the result in another.

The attached example has data in the two worksheets July2015 and MonthStats. What I am trying to achieve is that a sum within the monthly stat column references the data in the July2015 worksheet to return the relevant figures.

So in my example in cell B12 of the MonthStats worksheet the sum would calculate how many Fire case types there were on 01 July in the July2015 worksheet. This sum would need to reference columns C & E which deal with type and quantity, so the answer for 01 July would be 3.

I then also need a similar sum for each Case Officer, so in Cell B3 in MonthStats the answer would be two.

My other sticking point is the sheet is used by folks, with less excel skills than even me, so would welcome any suggestions as to how to make the necessary monthly updating of formulas, pain free.

Thanks for reading, hope my explanation is clear, had some trouble posting....

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro needed for time calculation and auto insert	ballst	Excel Programming	8	05-21-2015 03:54 PM
'Monday to Friday' Date calculation help needed	ballst	Word	10	12-16-2014 09:51 AM
Paste special an Excel range into Outlook as an Excel Worksheet	charlesh3	Excel Programming	3	02-04-2013 04:33 PM
How to summarise different worksheet to a summary worksheet	samkiewhock	Excel	1	09-06-2012 03:34 AM
"Auto-populating" data-worksheet to worksheet.	meggenm	Excel	4	02-04-2012 02:04 AM