• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 807
  • Last Modified:

Excel 2010 count column where

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.
0
edrz01
Asked:
edrz01
1 Solution
 
Jared_SCommented:
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.
0
 
SteveCommented:
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.
0
 
edrz01Author Commented:
Thank you Jared_S!!!! I use 2010, but knew where to look... that fixed the problem! Thanks again.
0
 
Seaton007Commented:
If you want to do it with a formula, then here is an example: =IF(A1="","0")
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now