Sum values, by month, in another worksheet
 

Hi All,

I have two sheets: Master Log & Summary. The master log contains many
rows, each having a date assigned to it. The Summary sheet is used to sum
totals and present to the board.

I would like to create a sum formula in a cell in the Summary sheet, that
looks for all rows where the Reading Date is in January. This formula would
go to the Mechanics column and sum all values listed for the month of
January. I don't want the formual to be year specific, just month.

Any suggestions?


--
Carlee

Sum values, by month, in another worksheet
 

In Summary,

Put something like this in the desired cell:
=SUMPRODUCT((TEXT('Master Log'!A2:A100,"mmm")="Jan")*('Master
Log'!A2:A100<""),'Master Log'!E2:E100)

Above assumes "Reading dates" are within A2:A100, "Mechanics" values within
E2:E100 in sheet: Master Log. Adapt ranges to suit.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Carlee" wrote:
Hi All,

I have two sheets: Master Log & Summary. The master log contains many
rows, each having a date assigned to it. The Summary sheet is used to sum
totals and present to the board.

I would like to create a sum formula in a cell in the Summary sheet, that
looks for all rows where the Reading Date is in January. This formula would
go to the Mechanics column and sum all values listed for the month of
January. I don't want the formual to be year specific, just month.

Any suggestions?


--
Carlee