M
Michael
I have a Column of Amounts and a column of Dates. I want to find the total
Amount spent in the first week of Januray, Second week, etc.
I can write a complex "=if(and" statement but I'm trying to limit the imput
in the cell to make it easier over the year. Is there a better way to
calculate it?
ie. "If Cell A1:A31 = january 4 thru january 10 returen the sum of cell
B1:B31"
My problem is I only want the cells that correlate with the cells that fit
the range?
So A1 and A15 might apply so I'd want B1 and B15 to add togther?
Amount spent in the first week of Januray, Second week, etc.
I can write a complex "=if(and" statement but I'm trying to limit the imput
in the cell to make it easier over the year. Is there a better way to
calculate it?
ie. "If Cell A1:A31 = january 4 thru january 10 returen the sum of cell
B1:B31"
My problem is I only want the cells that correlate with the cells that fit
the range?
So A1 and A15 might apply so I'd want B1 and B15 to add togther?