CODEWITHSUNDEEP
excel
Francis
Francis

Reputation: 129

SUBTOTAL not displaying results?

I have a table with filtered results from another sheet and am trying to use a SUBTOTAL formula at the bottom, but for some reason it's not working, since it's simply blank.

Here is an example from one of the columns:

Example

Each column has the following formula returning values seen in the image:

=IFERROR(MID(LEFT(Functions!M3,FIND("*",Functions!M3)-1),FIND("@",Functions!M3)+1,LEN(Functions!M3)),"")

And the SUBTOTAL at the bottom is:

=SUBTOTAL(9,[Missing Miles])

I would be thankful for any help I can get regarding this.

Cheers,

Francis

Upvotes: 1

Views: 365

Answers (1)

Scott Craner
Scott Craner

Reputation: 152505

That is because MID returns text and not a number. Use this:

=IFERROR(--MID(LEFT(Functions!M3,FIND("*",Functions!M3)-1),FIND("@",Functions!M3)+1,LEN(Functions!M3)),0)

as the formula in the cells. it will force the text that looks like a number to an actual number.

Upvotes: 1

Related Questions