On 2002-04-16 05:02, kcolls wrote:
That my be the answer but it is B_3 to the infinate number to typing/clicking up to B1993 eventually may not be enough?
On 2002-04-15 15:13, Aladin Akyurek wrote:
=SUMPRODUCT((RIGHT(ROW(B3:B23))+0=3)*(B3:B23))
On 2002-04-16 09:37, Yogi Anand wrote:
On 2002-04-15 15:13, Aladin Akyurek wrote:
=SUMPRODUCT((RIGHT(ROW(B3:B23))+0=3)*(B3:B23))
Hi Aladin:
Why not simply
=SUMPRODUCT((RIGHT(B3:B23)="3")*(B3:B23))
after all it is only a string we are dealing with at that point
Please advise if there is a specific advantage to converting "3" into a numeric digit with "3"+0
Your insightful solutions are always a delight!