+ Reply to Thread
Results 1 to 2 of 2

COUNTIF one cell has specific value and another is blank

  1. #1
    Registered User
    Join Date
    11-04-2021
    Location
    Finland
    MS-Off Ver
    MS Office 365
    Posts
    1

    COUNTIF one cell has specific value and another is blank

    Hi!

    I'm not sure what I'm doing wrong, but I've tried making a function that counts the amount of cases where in a sheet called Tiedot, G2:G300 is "Sini R" AND K2:K300 is blank. Everytime I think I've figured it out there's an error.

    I'd be grateful if someone took the time to write that function so I can see what I've been doing wrong.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,623

    Re: COUNTIF one cell has specific value and another is blank

    Welcome to the forum.

    What is the formula? Are the 'blanks' really blank?

    There are instructions at the top of the page explaining how to attach your sample workbook.

    A good sample workbook has just 10-20 rows of representative data. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Countif if the cell value is not blank
    By renjithvakkayil in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-11-2019, 04:34 AM
  2. [SOLVED] Countif only cell is blank
    By DarthBrute in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-10-2018, 04:51 PM
  3. [SOLVED] Countif until blank cell (mutiple blank cells)
    By plasma33 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-07-2015, 01:14 PM
  4. [SOLVED] Copy worksheet with specific name and no blank cell in a specific range
    By graiggoriz in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-05-2013, 11:50 AM
  5. Replies: 3
    Last Post: 08-20-2013, 10:39 AM
  6. Deleting rows if specific cell is blank or have specific text
    By JoaoFerreira1985 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-11-2013, 01:18 PM
  7. Countif only when a cell is blank.
    By Stevie-B in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-03-2008, 10:58 AM

Tags for this Thread

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