Quote:
Originally Posted by ArviLaanemets
Let's say, you numbers are in range A2:A21.
Into second column enter the formula (p.e. into cell B2)
NB! The formula refers to next row in column A!
Copy the formula down into range B2:B21.
Into any cell where you want the end result, enter the formula
Code:
=SUMIF($B$2:$B$21,TRUE,$A$2:$A$21)
|
ArviLaanemets,
Thanks for the post. Your formula works, but I guess I should have been more specific... your method while it works, really won't work for what I need, it will clutter up she sheet making it confusing.
I have attached a sample spreadsheet to illustrate. My numbers go from 1 to 75 across the top starting at B1. picks start at A6 and will go down many rows... 100 or so.
is there a way to accomplish the same results that your formula returned, but a different way or with a Macro?
Thanks again for you efforts.
JBF