COUNT / INDIRECT / ADDRESS question

Board Regular
What have I done wrong here?

=COUNT(INDIRECT(L36):INDIRECT(M36))

L36 = \$P\$33
M36= \$S\$33

Both returned by the ADDRESS function.

Thanks for any help.

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

VoG

Legend
Your formula works in Excel 2007 but try

=COUNT(INDIRECT(L36&":"&M36))

Jonmo1

MrExcel MVP
=COUNT(INDIRECT(L36 & ":" & M36))

barry houdini

MrExcel MVP
Formula works for me,

What values are in P33:S33? What result do you expect? COUNT will only count numbers (formatted as numbers) within that range

Board Regular
Thank you, awesome.

Replies
3
Views
225
Replies
6
Views
193
Replies
11
Views
263
Replies
2
Views
482
Replies
5
Views
419

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

1,151,560
Messages
5,765,100
Members
425,258
Latest member
brentmitchell

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back