Help needed for sum / range calculation from one worksheet to another
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....
|