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     www.energyefficientbuild.com.   Mar-19-2017
question by Happy Pups Bed and Biscuit:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!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.

Polom
2 Mires

Mika
Harper
2 Sidelko
Milliken
Huntley
7
9