ExcelBanter - Could the "Criteria" in COUNTIF function be a cell reference?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Could the "Criteria" in COUNTIF function be a cell reference? (https://www.excelbanter.com/excel-worksheet-functions/31053-could-%22criteria%22-countif-function-cell-reference.html)

JohnSheenWSN

Could the "Criteria" in COUNTIF function be a cell reference?

N Harkawat

yes
=countif(a1:a100,B1)

"JohnSheenWSN" wrote in message
...

Don Guillett

Norman was kind to answer your question. However, is there some reason you
couldn't have TRIED it first?

--
Don Guillett
SalesAid Software

"JohnSheenWSN" wrote in message
...

All times are GMT +1. The time now is 02:37 AM.