Excel 2010 count column where

Posted on 2012-08-28
Last Modified: 2012-08-28
I have a formula in a cell that counts a column for a specific record and a secondary column as the filter.

=COUNTIFS(B:B,"NMC",D:D, "*Trucks*")

However, IF the Cell (in this case is F3) where the formula resides is Null, I want to display the number Zero (0).

I've tried several iterations but have not been successful. Can you point me in the right direction or provide a solution.
Question by:edrz01
    LVL 12

    Accepted Solution

    If you're using 2007, go to Excel Options > Advanced > Display options for this worksheet, and then make sure the "Show a zero in cells that have a zero value" is checked.

    I think the checkbox is under tools > view in earlier versions.
    LVL 24

    Expert Comment

    I am sorry, but I am not getting the question.
    The result for the formula if no matches will be zero (not null)
    So I am not getting where the Null comes in? Null is not genrally an Excel term.

    An example workbook, with detail of the desired outcome may help.

    Author Comment

    Thank you Jared_S!!!! I use 2010, but knew where to look... that fixed the problem! Thanks again.
    LVL 12

    Expert Comment

    If you want to do it with a formula, then here is an example: =IF(A1="","0")

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Lately there has been a variety of news related to U.S. employment.  Stories about worker productivity, automobile and airline unions, low employment and foreign laborers have frequented the news.  Each story has good and bad attributes we might arg…
    Companies keep a much closer eye on costs today, so changing to new Technology – Microsoft Office 365 is the smartest move to take.
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now