Sunday, March 19, 2017

yogi_Count The Number Of Entries In Column A With The Stipulation That Items Beginning With A Number Are Counted That many Times While Ignoring Other Numbers

Google Spreadsheet   Post  #2134
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Mar-19-2017
question by Happy Pups Bed and Biscuit:!topic/docs/UJRB2N1NmVA;context-place=forum/docs

How do i add numbers from cells when the cell contains a number and text

I have 20 cells in one column.  i fill the cells in with names.  I am having the final formula count how many cells are filled in but sometimes i have to put a 2 and text in one box in which case I would like it to count that box twice, or 3 and count 3 times.  Any Ideas on how to do this?  The 7 at the bottom is counting the cells with something in them by the =COUNTA(A1:A8).  I would like the 9 cell to count the number of cells with stuff in them, plus where there is a number add it as that many instead of just one.  Please Help.

2 Mires

2 Sidelko

No comments:

Post a Comment