Results 1 to 2 of 2

Colunting Blank Cells

Threaded View

  1. #1
    Registered User
    Join Date
    04-23-2011
    Location
    Sydney Australia
    MS-Off Ver
    Excel 2003
    Posts
    11

    Colunting Blank Cells

    Hi All,

    What I want is when cells A2 & B2 are blank, then 1 is counted in the Total Column.

    What I then want to now achieve on top of this function is when cell value of C2 & D2 are also blank, then another 1 is added into the Total Column.

    The same will occure for cells E2 & F2 giving a total of 3 in the end column.

    I want to count two blank cells as 1.

    Thanks

    Ray
    Attached Files Attached Files
    Last edited by ray963; 05-21-2011 at 08:04 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1