I have been utilizing the following formula in excel. Now that it is closer to the new year I need to add the year as well as the month. this is my current formula.
=IF(MONTH(B21) = 1,SUM(D21+E21+F21+G21),0)
so I need to add if month/year = 2007 then sum....etc.
I would appreciate any help on this. Thanks!
2006-10-24 04:42:46 · 5 answers · asked by Anonymous in Science & Mathematics ➔ Mathematics
=IF(AND(MONTH(B21)=1,
YEAR(B21)=2007),
SUM(D21+E21+F21+G21),0)
2006-10-24 04:45:47 · answer #1 · answered by Deep Thought 5 · 3⤊ 0⤋
Are the numbers to the the ideal option of the / character constantly one digit in length? if so, paste this formula in D16 =SUMPRODUCT((N(precise(A1:A1000, a million)=precise(D15,a million)))*(B1:B1000)) in the adventure that your documents is going previous row 1000, substitute the masses to a pair huge style larger than what you have. The above formula assumes all your documents in column A starts with g/z.
2016-12-28 03:43:22 · answer #2 · answered by ? 3 · 0⤊ 0⤋
I am good in Excel
if u want a help email me the Excel sheet
but that can not be understood
2006-10-24 04:49:38 · answer #3 · answered by mozakkera 2 · 0⤊ 1⤋
This is not clear, send me a message and I'll try to help you
2006-10-24 04:48:19 · answer #4 · answered by Steiner 7 · 0⤊ 0⤋
=IF(AND(MONTH(B21) = 1, YEAR(B21) = 2007), SUM... etc.
2006-10-24 04:47:16 · answer #5 · answered by Puzzling 7 · 2⤊ 0⤋