ExcelBanter - COUNTIF

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

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

- - COUNTIF (https://www.excelbanter.com/excel-discussion-misc-queries/52554-countif.html)

qwerty

COUNTIF

I have a COUNTIF(G23:G10007;"<1000") but I need the range to be variable.

Excel can do this???

Regards in advance

JE McGimpsey

COUNTIF

See

http://cpearson.com/excel/named.htm#Dynamic

In article ,
qwerty wrote:

I have a COUNTIF(G23:G10007;"<1000") but I need the range to be variable.

Excel can do this???

Regards in advance

Bob Phillips

COUNTIF

Try this

=SUM(--(OFFSET(G23,,,MAX(IF(G23:G65535<"",ROW(G23:G65535 )-ROW(G23)+1)))<100
0))

it is an array formula, so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)

"qwerty" wrote in message
...
I have a COUNTIF(G23:G10007;"<1000") but I need the range to be variable.

Excel can do this???

Regards in advance

All times are GMT +1. The time now is 09:14 PM.