Consulting

Results 1 to 2 of 2

Thread: (Question) Make Subtotal ignore ="" Cells

  1. #1

    (Question) Make Subtotal ignore ="" Cells

    Hello


    I'm using this formula to number the amount of cells in $D$9;D500 with data in them:
    =IF(SUBTOTAL(3;$D$9:D9)=C8;"";SUBTOTAL(3;$D$9:D9))
    But the formula does not ignore cells with
    =""
    in them, as they're technically not empty, anyone know a way without VBA to resolve this ?

  2. #2
    No one ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •