Breaking down a cell to create a function
Hi,
You don't actually say what you want to do but this takes the year from
dates in column A and compares them to the year of a date in C1 and if the
same sums column B
=SUMPRODUCT((YEAR(A1:A13)=YEAR(C1))*(B1:B13))
Mike
"Robert" wrote:
I'm trying to create a flow graph by using current information on my
spreadsheet. I have a column of dates in this format 01/05/06. I trying to
find a formula that will only use the year in that format, so I can show
trends by the year. Please help! I've been trying this for a week and can't
figure it out. And I don't even know if it's possible.
|