Go Premium for a chance to win a PS4. Enter to Win

x
Solved

# count number of items in column 'D' where cell 'G' [in same row] is not blank

Posted on 2014-01-06
Medium Priority
291 Views
Happy new Year EE community

is there a formula to do this?

column 'D' contains text. i.e. Mon, Tues, Wed, etc

so, if D6=Mon and G6 is blank do not count

if D6=Mon and G6 is not blank count it

so, if D16=Wed and G16 is blank do not count

if D16=Wed and G16 is not blank count it

So what I want to end up with is a table that will show me

Mon = 10
Tues = 4
Wed = 9

etc

Obviously I can't use Countblank as I need to count items in two columns

Thanks
0
Question by:Jagwarman

LVL 13

Accepted Solution

dhoffman_98 earned 1500 total points
ID: 39759323
You can do an if statement that says IF column D has a value, and column G has a value then to place a 1 in a hidden column farther to the right in the spreadsheet, and then have a SUM statement where you want your total count to show up that counts the values in the hidden column.
0

Author Comment

ID: 39759419
that works for me. Thanks
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
###### Suggested Courses
Course of the Month10 days, 18 hours left to enroll