Count cells

[Immortal2014]

Hi guys, i want to count cells only if the formula in an area returns a number.
So i use this formula and then i drag and drop down for other cells.

Please Login or Register  to view this content.

Cell F1 and others contains this formula

Please Login or Register  to view this content.

But it count all cells, even the cells who dont have any number.
What i have done wrong?

[jason.b75]

COUNTA will count all cells that are not empty, including formula blanks. Use COUNT instead.

[Immortal2014]

Thanks for your opinion but COUNT doing the same thing. Any other advice please?

[jason.b75]

Not without more information.

What results are you getting from the formula?

What results are you expecting?

[Immortal2014]

Ok,
so lets say in column A and B,
If the formula SUMIFS in cell B1 returns any number i want in cell A1 the number 1. If returns nothing i want cell A1 empty.
If the formula SUMIFS in cell B4 returns any number i want in cell A4 the number 1. If returns nothing i want cell A4 empty.
I want to count only the cells which returning any number from formula, but its a list and some formulas in rows doesnt return numbers.

[jason.b75]

So you just want

=IF(ISNUMBER(F1),1,"")

No need to count anything.

[Immortal2014]

Ohh... Formula in F1 doesnt return any nymber and it gives me 1, same result if return number or not..

[jason.b75]

That doesn't make sense, are you saying that the formula is still giving the wrong results?

[Immortal2014]

And yes! i need to count all cells with formulas which returns any number. But doesnt are all results one after one. Some rows through list are without numbers.

[Immortal2014]

Yes it still give wrong result. If i delete the formula from F1, formula in A1 works good.
I dont know if something goes wrong with the F1 formula, the formula in A1 counts the formula and not the result of this. The SUMIFS formula works and give me the results that i want.

[jason.b75]

Something I did not pay much attention to earlier.

You're counting cells that contain a SUMIFS formula, SUMIFS will always return a number, meaning that every cell with a formula will be counted.

[Immortal2014]

Yes youre right, i was have #"" in format and it not showing zeros.. Sorry.
So i try now (in real area list starts from row 10)

Please Login or Register  to view this content.

and it count only the cells which return 1 or higher.
Now the first cells formula which return a number 1 or higher in column E is in third row of list and in cell C10 i take the number 3. I want to take the number 1.
The next number >=1 is in fifth row and it gives in C14 number 5, i want to take number 2.
Is this possible?

[jason.b75]

Try this one

=IF(N(F1),COUNTIF($F$1:$F1,">0"),"")

[Immortal2014]

Ohhh jason you are the best! Thank you very much for your solution, i searching a long long time for this and thanks to you i have now the solution. Thanks again.