Results 1 to 4 of 4

Countif multiple conditions

Threaded View

  1. #1
    Registered User
    Join Date
    01-20-2008
    Location
    Sevenoaks, Kent Great Britain
    MS-Off Ver
    2010
    Posts
    54

    Countif multiple conditions

    Hi I want to be able to look at two columns and set a criteria to count. I want to look at column A and if its blank then look at column B and if it has a value of more than 0 then count.

    A B
    1 1.00
    2 Yes 4.78
    3
    4 5.00
    5 Yes 4.89
    6 11.99

    So this example would count 3

    If that all makes sense.

    David
    Last edited by EXCELNEWCOMER; 01-15-2010 at 02:22 PM.

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