COUNTIF without an array

Hi there,

I've been looking around forums with regards to COUNTIF functions without an array but I can't seem to find the perfect solution for my situation.

Basically, I need to count only certain cells and if it satisfies the conditions. Eg. If COUNTIF could allow non-range cells, it'll look something like COUNTIF((A1,B2,C3),">3") and the result would be 2 if according to the sample table below

A B C
4 2 3
3 5 4
6 1 2

Thus I would be selecting individual cells, counting them if it satisfies the condition.

Hope someone could help!

PS I've tried using a formula,with respect to the above table, COUNTIF(A1:A1:B2:B2:C3:C3,">3") but it doesnt seem to be correct.

Thanks

welcome to the forum. any reason why you are avoiding an array? you can't do that with COUNTIF. there are workarounds without array but i don't see the need to.
=COUNTIF(A1,">3")+COUNTIF(B2,">3")+COUNTIF(C3,">3")
=SUM(--(A1>3),--(B2>3),--(C3>3))

not sure if the concern is to press CTRL + SHIFT + ENTER for array formulas. some array formulas may not require it. like this for eg.
=SUMPRODUCT(--(N(INDIRECT({"A1","B2","C3"}))>3))

Hi, Pinkkypie - don't make us re-invent the wheel. Please upload a small sample workbook.
Remove any personal or proprietary information.
Try to use your original layout so our solutions fit your workbook.
Include “realistic” data showing any variations the code or formula must address.
Highlight the formula cells and simulate some results to help us visualize what you want.

To attach a workbook:
Click Edit Post (or just start a new reply.)
Click Go Advanced
Scroll down to Manage Attachments and click.
Now click Browse, find your file, then click Upload. Simple!

My understanding is that you want a count of >100A readings for each of the 44 machines. COUNTIFS works just fine for that.
Paste this in a column next to the data on row 15 and copy down:

Please Login or Register  to view this content.

You're most welcome! And since you're new... Clicking the Add Reputation star below helpful posts is a nice way to show appreciation to those who contributed. Regards - Lee