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

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

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
Jagwarman
Asked:
Jagwarman
1 Solution
 
dhoffman_98Commented:
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
 
JagwarmanAuthor Commented:
that works for me. Thanks
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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