+ Reply to Thread
Results 1 to 4 of 4

Formula that counts whether two cells in a row contain data.

  1. #1
    Registered User
    Join Date
    09-23-2015
    Location
    Buntown, USA
    MS-Off Ver
    Microsoft Office 2013
    Posts
    4

    Formula that counts whether two cells in a row contain data.

    Hello!

    I need help getting a formula together. Is there a formula I can put in one box that counts how many times there is text in column G AND numbers in column J in the same row? I can do this one by one but I figure there is a better way for this. Attached is a picture that demonstrates what I am talking about. Is there a formula I can enter where, in the example pictured, it would return the number two?

    Thanks for your time!
    Example.jpg

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Formula that counts whether two cells in a row contain data.

    Maybe:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    or

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    BSB

  3. #3
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Formula that counts whether two cells in a row contain data.

    Try something like this:
    Please Login or Register  to view this content.
    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  4. #4
    Registered User
    Join Date
    09-23-2015
    Location
    Buntown, USA
    MS-Off Ver
    Microsoft Office 2013
    Posts
    4

    Re: Formula that counts whether two cells in a row contain data.

    These both worked... Thanks so much!

    -Hotdog Buns

+ 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. [SOLVED] Sumproduct formula counts blank cells as instances
    By dlee959 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-24-2014, 01:37 PM
  2. Replies: 1
    Last Post: 05-21-2014, 02:30 PM
  3. [SOLVED] Problem adapting a formula that counts only filtered cells
    By ABramley in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-24-2013, 10:45 AM
  4. Replies: 4
    Last Post: 11-28-2012, 01:43 PM
  5. Formula that counts cells and returns a number
    By blburden in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-20-2012, 10:43 PM
  6. [SOLVED] Average Formula that counts blank cells
    By ChrisHallas in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-01-2012, 08:20 AM
  7. [SOLVED] How do i find the counts of data with a condition of other cells
    By veeramis in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-14-2006, 03:10 PM

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