ExcelBanter - counting cells with an integer in

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - counting cells with an integer in (https://www.excelbanter.com/excel-discussion-misc-queries/151959-counting-cells-integer.html)

Andy_Trow

counting cells with an integer in

Max

counting cells with an integer in

counting cells with an integer in

Assuming source numbers in A1:A10
then perhaps, in say, B1:
=SUMPRODUCT(--ISNUMBER(SEARCH(".",A1:A10)))

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Max

counting cells with an integer in

Oops, correction. It should be:
=SUMPRODUCT((NOT(ISNUMBER(SEARCH(".",A1:A10)))*(A1 :A10<"")))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

All times are GMT +1. The time now is 04:14 AM.