Help with formula

[JordanB04]

Hi,

I would like to write a formula that says, every time there is a number greater than 0 in cells, a1, a2, a3, a4, a5, a6, a7, a8 then add a 1 to cell a9. I hope that makes sense.

So even if there is a 4 in cell a1, add a 1 to a9 etc.

Thanks in advance.

Jordan

[TMS]

=COUNTIF(A1:A8,">0")


Regards, TMS

[JordanB04]

You're a genius! Thank you so much.

[arlu1201]

Jordan,

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[TMS]

You're welcome. Please follow Arlette's guidance and change your thread title.

While you're doing that ...

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save