vzachin
01-07-2008, 11:18 AM
hi,
i need to add the number of entries based on month & year.
in column A12, i have numbers ; in column B12 i have dates.
in cell B3, i'm looking to add up the numbers in Column A12 for the month of January 2008.
i tried sumif but that didn't work out.
is there a formula for this or do i need to write some code ?
thanks
zach
i need to add the number of entries based on month & year.
in column A12, i have numbers ; in column B12 i have dates.
in cell B3, i'm looking to add up the numbers in Column A12 for the month of January 2008.
i tried sumif but that didn't work out.
is there a formula for this or do i need to write some code ?
thanks
zach