If Formula for Cumulative Totals

Hi, hoping someone can help as I'm struggling with my final hurdle

I am creating a workflow type of form.

I am using the current formula which works very well

=IF(F3<>"",B1)

This is if I place anything in the cell F3 then whatever the value I have in B1 will be placed in my cell

I would like to expand this further so that
if I place anything in the cell F3 then whatever the value I have in B1 will be placed in my cell (as is)
If I place anything in the Cell F4 then whatever the value I have in B1 will be added to the value of the formula above
If I place anything in the Cell F5 then whatever the value I have in B1 will be added to the value of the formula above

ie my cell is B2
The value in B1 is 1

If I place an X in F3, B2 will display 1
If I place an X in F4, B2 will display 1
If I place an X in F5, B2 will display 1

If I place an X in F3 and F4, B2 will display 2
If I place an X in F3, F4 and F5, B2 will display 3

So basically however many X's I have in F3, F4 and F5 will be counted up and displayed in B2

I hope this makes sense

Thanks in advance for your assistance on this

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new here, I will do it for you this time.)

Try COUNTIF:

=COUNTIF(F:F,"X")

Of course you can:

=COUNTIF(Sheet1!F:F,"X")

LOL!!! No need for flowers - a 'thank you' is enough, and I've had that.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.