Results 1 to 3 of 3

Help to count cells in a time range that meet a condition

Threaded View

  1. #1
    Registered User
    Join Date
    07-06-2017
    Location
    Fortaleza
    MS-Off Ver
    2016
    Posts
    1

    Help to count cells in a time range that meet a condition

    Hi there,

    Please, I need help with this.

    I have a series of hourly temperature data (C) for a year (N=8760) and I need to:

    A) Count the number of cells (Column B) between this time range in a year: 01:00 to 08:00 AND 23:00 and 00:00.
    I know the result is 2920 and would like to get that without using filter with SUBTOTAL.

    B) Count the number of cells at the same time range that are lower than 30, in column C.

    Year.jpg
    I have been working with that, obtaining a partial solution using COUNT.IFS for a day (just one time interval), but when I have a year and different time intervals in a day….

    Best regards,
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count cells meet the criteria and date range
    By Горштак in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-11-2020, 05:41 AM
  2. Count Value of Cells that meet a certain condition
    By cdhampshire in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-17-2020, 06:09 AM
  3. Replies: 2
    Last Post: 09-02-2017, 09:30 PM
  4. Replies: 12
    Last Post: 09-02-2014, 02:07 PM
  5. Count unique values within a range that meet a specific condition
    By CSS in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 06-24-2013, 02:00 PM
  6. [SOLVED] count number of cells which meet a particular condition for an individual
    By rohit43 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-18-2013, 11:20 AM
  7. [SOLVED] Counting cells that fall in a date range AND meet a Yes/No condition
    By pentatonic145 in forum Excel General
    Replies: 2
    Last Post: 05-01-2012, 04:26 PM

Tags for this Thread

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