Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default Count If value is greater than 12 and within the past 30 days

I'm trying to create a spreadsheet and nothing I try is working and I have been at this for days now.

I need to count how many times in the last 30 days an employee has worked more than 12 hours.

I have it so that A3:A308 are dates (3/1/2018 through 12/31/2018) and the employee names are listed in the first row (just to test it out I'm using B1 through P1). Row 2 is where i want to insert the formula.

So for B3 through B308, I will enter number of hours worked each of those days.

I want B2 to tell me how many times in the last 30 days based on TODAY's date and the dates in A3:A308 that the value in B was greater than or equal to 12.

HELP PLEASE!!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,872
Default Count If value is greater than 12 and within the past 30 days

Hi Vanessa,

Am Thu, 29 Mar 2018 17:02:46 +0100 schrieb Vanessa Sales:

I need to count how many times in the last 30 days an employee has
worked more than 12 hours.

I have it so that A3:A308 are dates (3/1/2018 through 12/31/2018) and
the employee names are listed in the first row (just to test it out I'm
using B1 through P1). Row 2 is where i want to insert the formula.

So for B3 through B308, I will enter number of hours worked each of
those days.


try in B2:
=SUMPRODUCT(--($A$3:$A$308=TODAY()-30),--($A$3:$A$308<=TODAY()),--(B$3:B$308=12))
and copy to the right.


Regards
Claus B.
--
Windows10
Office 2016
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count if past today () - 30 days Scott_goddard Excel Worksheet Functions 3 April 20th 10 04:59 PM
Caluclating days past due מיכאל (מיקי) אבידן Excel Discussion (Misc queries) 0 March 29th 10 07:26 PM
Rolling date looking 30 Days past Chris Excel Worksheet Functions 2 August 27th 09 02:36 AM
Number of days past due rrupp Excel Worksheet Functions 2 March 18th 09 06:36 PM
Count No of days past due Mrs H Excel Worksheet Functions 4 February 6th 09 03:39 PM


All times are GMT +1. The time now is 06:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"