How to increase denominator by 1?

Hey, new here and have found answers before by a google search and wanted to join as this is a great forum.

I am trying to keep a running total of the number of patients I see per day. I hand enter the total seen and then have the formula of (cell/#). The cell is the sum of all the cells in that row which is the number of patients. # is the number of cells. I would like the information to be UTD and thus have the denominator increase by 1 every time information is added to a new cell. So, my number of patients per day is always accurate, not diluted by an empty cell. The denominator is a constant that I count all the days I will work and enter it before hand, so only the nominator changes.

Any ideas?

Thank you in advance for your time

sugarray

Hi sugarray and welcome to the forum

im not entirely sure what you are trying to do, but try playing around with countA() - it will count all non-empty cells

Do you have sample data?

Hi
If the number of cells you want to count are in row 2 use =COUNT(A2:A1000) which will count the number of cells containing a number. Adapt range to your needs

Thanks Pepe Le Mokko, that worked, at least I think. I do the math on a calculator and check it.

sample data

The most days in a month is 31, so I have 1-31 in row 3, column B - AF. Then Row 4-14 is January - December. I then input my daily count in the corresponding date column for January. I have 9, 17, 12, 18, 9, 18, 23, 21, 11, 20, 25,7, 12, 18, 20, 10 and today is blank. I need the denominator to then increase by 1 each time I enter data in a cell in that row. The above COUNT worked great. Let me try it for other cells, as I work in 2 different places and want to separate that data too.

=AH3/(COUNT(B3:AF3)) => this works perfect, but is both work sites together.

So, now how do I separate the data:

=(D3+H3+I3+K3+O3+P3+R3+W3+Y3+AC3+AD3+AF3)/COUNT(D3+H3+I3+K3+O3+P3+R3+W3+Y3+AC3+AD3+AF3). These are the cells corresponding to one site, but when I put it in there to count them for the denominator, it is way off. I did have () around COUNT as well, but that didn't change it. Tried [] and that didn't work either, just got an error.

Thank you!!

sugarray

count() will only count numbers, it will ignore text and blank cells, thats why I suggested countA()...it will caount everything except blank/empty cells

Do the cells you are counting have the same - or at least - similar headings? If so, you could maybe use sumifS() and countifS() instead, based on the headings.

It will be far easier to help you if you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

no it doesnt. are you sure the numbers are actually numbers/values, and not text that just looks like a number?

test with =isnumber() FALSE indicated text

will try again

Please dont upload pictures