2nd attempt ~ Faster/Shorter formula
I'm stumped
"Luke" wrote in message
...
Yes, a bit complicated. Formula in B3 (fill right) returns #VALUE! If I
jockey the formula around a bit and put it in C3 (fill right) I get all
blanks in row 3.
I will keep after it. Please let me know if you see something that needs
corrected. I'll do the same.
"Harlan Grove" wrote in message
...
"Luke" wrote...
So Sorry, I Should have said "Same Year". I bow in disgrace.
...
Using years makes the formulas a bit more complicated.
B3:
=IF(AND(SUMPRODUCT(--(YEAR($A$1:A$1)=YEAR(B$1)))=0,ABS(SUMPRODUCT(--(YEAR(B$1:$IV$1)=YEAR(B$1)),B$2:$IV$2)-30)<=3),SUMPRODUCT(--(YEAR(B$1:$IV$1)=YEAR(B$1)),B$2:$IV$2),"")
Fill right as needed.
|