Count and Countif

[alliesrq]

I thought count and Countif could use cell references to count how many results were in a particular column or row.

example =count(A8,a10,a,11,a15,a22"W").

I have tried the example with count and countif and keep getting error messages.

Can anyone assist?

Thanks

Allie

 

[Joe4]

Welcome to the Board!

The COUNT function only counts numbers. So, all the arguments in that function must be ranges or numbers.
The COUNTIF function can count the number of cells in a range meeting some criteria. There is only one argument for range, so if the range you want to look at is not continuous, then you need to do as shown here:
https://exceljet.net/formula/countif-with-non-contiguous-range

 

[alansidman]

Look at these two links

https://www.techonthenet.com/excel/formulas/count.php

https://www.techonthenet.com/excel/formulas/countif.php

 

[Fluff]

Hi & welcome to MrExcel
Maybe something like
=COUNTIF(A8:A22,"W")

 

[alliesrq]

Fluff:

That works. However, the criteria that I am trying to count is scattered, and not in a reange.

 

[Joe4]

That works. However, the criteria that I am trying to count is scattered, and not in a reange.

See the link I provided in my reply.
It shows you EXACTLY how to do that.