+ Reply to Thread
Results 1 to 4 of 4

Count how many rows contain data in two specific columns at the same time

  1. 07-18-2018, 08:00 AM #1
    DMA
    DMA is offline
    Forum Contributor
    Join Date
    07-08-2008
    Location
    New York City
    MS-Off Ver
    2013-2016
    Posts
    157

    Count how many rows contain data in two specific columns at the same time

    Hello,
    Is there a way to specify in a formula that I want to check how many rows contain data in columns G and H at the same time?
    I would like just a formula but if there's no other way i'll end up using VBA.
    Thanks.
    Reply With QuoteRegister To Reply
  2. 07-18-2018, 08:06 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Count how many rows contain data in two specific columns at the same time

    Yes!

    The function you need is COUNTIFS:

    =COUNTIFS(G:G,"<>",H:H,"<>")
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 07-18-2018, 08:43 AM #3
    DMA
    DMA is offline
    Forum Contributor
    Join Date
    07-08-2008
    Location
    New York City
    MS-Off Ver
    2013-2016
    Posts
    157

    Re: Count how many rows contain data in two specific columns at the same time

    Thank you! Perfect!
    Reply With QuoteRegister To Reply
  4. 07-18-2018, 08:46 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: Count how many rows contain data in two specific columns at the same time

    You're welcome!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. To paste specific data in specific columns and rows to specific table in powerpoint
    By ell_ in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-20-2017, 02:09 AM
  2. Group together rows using specific data from 2 different columns
    By DSET13 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-28-2015, 06:51 PM
  3. Delete Specific Rows That contain certain data in two columns
    By josephir1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2014, 04:40 PM
  4. Search for specific data and count number of rows till empty Cell
    By kjanani30 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-04-2013, 06:05 AM
  5. [SOLVED] Do I use Count-IF or other formula to pull data from specific columns?
    By jordan1214 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-13-2013, 09:14 PM
  6. HALP! Count and Insert Rows and Specific Data on Another Sheet.
    By goradiar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2012, 08:00 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1