How to add to existing formula

  • Thread starter Thread starter SS
  • Start date Start date
S

SS

I am using the formula below which works good.

=COUNTIF(H4:H26,">0.00")

I now want to add in cells H31:H55 and H60:H81.
When I try to do this I get too few or not enough arguments.

I have tried various permutations but cant get it. (lack of knowledge)
How would I construct this formula to include the additional cells.

thank you
 
SS said:
I am using the formula below which works good.

=COUNTIF(H4:H26,">0.00")

I now want to add in cells H31:H55 and H60:H81.
When I try to do this I get too few or not enough arguments.

I have tried various permutations but cant get it. (lack of knowledge)
How would I construct this formula to include the additional cells.

thank you
Click to expand...
Its ok now, I managed to get it working.
 
=COUNTIF(H4:H26:H31:H55:H60:H81,">0")

-----------------------
Ms-Exl-Learner
-----------------------


I am using the formula below which works good.

=COUNTIF(H4:H26,">0.00")

I now want to add in cells H31:H55 and H60:H81.
When I try to do this I get too few or not enough arguments.

I have tried various permutations but cant get it. (lack of knowledge)
How would I construct this formula to include the additional cells.

thank you
Click to expand...

Thanks for that formula thats a much shorter version than the one I
eventually arrived at.

thanks
 
Ron Rosenfeld said:
You need to set up separate COUNTIF functions and add them:

=COUNTIF(H4:H26,">0.00")+COUNTIF(H31:H55,">0.00")+COUNTIF(H60:H81,">0.00")

Note that the formula suggested by Ms-Exl-Learner is equivalent to

=COUNTIF(H4:H81,">0") and may not be what you want.
Click to expand...

Ron you are correct when I used the first formula (Ms-Exl-Learner) it added
everything.

The one you have given me with seperate COUNTIF functions was what I
eventually worked out.

Thanks all for contributions.
 
Back
Top