G
Guest
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?
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?