M
MIKE
My data looks like this
A B
1 Date Acquired Memo Cos
2 02/17/97 Computer 1,000.00
3 09/11/97 Video 15.040
4 09/13/97 Sign 105.54
5 04/08/98 Desk 150.00
6 07/23/98 Chair 75.00
7 1/1/00 Table 60.00
8 3/12/00 File 40.00
9 6/17/01 Light 65.00
10 10/11/01 Cube 850.00
11 12/4/02 Bin 125.00
1
13 Year
14 1997 1,120.54
15 1998 225.00
16 1999
17 2000 100.00
18 2001 850.00
19 2002 125.00
I am trying to write a SUMIF formula that will examine cells A1:A11 and if the YEAR in those cells is equal to YEAR in say cell A14 then it will sum the appropriate cells in C1:C11 and return a value of 1,120.54
The formula I am trying to write in cell C14 looks like this
=SUMIF(YEAR(A1:A11),?????,C1:C11
I am stuck on the ????? part.
Any thoughts
Thank
A B
1 Date Acquired Memo Cos
2 02/17/97 Computer 1,000.00
3 09/11/97 Video 15.040
4 09/13/97 Sign 105.54
5 04/08/98 Desk 150.00
6 07/23/98 Chair 75.00
7 1/1/00 Table 60.00
8 3/12/00 File 40.00
9 6/17/01 Light 65.00
10 10/11/01 Cube 850.00
11 12/4/02 Bin 125.00
1
13 Year
14 1997 1,120.54
15 1998 225.00
16 1999
17 2000 100.00
18 2001 850.00
19 2002 125.00
I am trying to write a SUMIF formula that will examine cells A1:A11 and if the YEAR in those cells is equal to YEAR in say cell A14 then it will sum the appropriate cells in C1:C11 and return a value of 1,120.54
The formula I am trying to write in cell C14 looks like this
=SUMIF(YEAR(A1:A11),?????,C1:C11
I am stuck on the ????? part.
Any thoughts
Thank