Countif or other formula needed for multiple data/critera results
I have a staffing spreadsheet that I need help on a formula.
Column G containing ECD dates, Column H containing CCO dates. What I am needing is: Return the sum of the count from Column G that contains a date of 1/1/2050, and a count for Column H that is equal to today(). |
Countif or other formula needed for multiple data/critera results
Hi,
Am Wed, 16 Apr 2014 01:48:39 +0100 schrieb cdmartin: Return the sum of the count from Column G that contains a date of 1/1/2050, and a count for Column H that is equal to today(). try: =SUMPRODUCT(--(G1:G1000=DATE(2050,1,1)),--(H1:H1000=TODAY())) Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
Thanks this still only produces a 0 as the return data which is invalid.
Quote:
|
Countif or other formula needed for multiple data/critera results
What I am needing is:
Return the sum of the count from Column G that contains a date of 1/1/2050, and a count for Column H that is equal to today(). Not sure exactly what's required. If you need two sums, then (1) the count from Column G that contains a date of 1/1/2050 is =COUNTIF($G:$G,DATE(2050,1,1)) and (2) the count for Column H that is equal to today() is =COUNTIF($H:$H,TODAY()) If you need the total of these two, add the two formulas. Notice that if you add the two formulas then any row that satisfies both (1) and (2) will be counted twice. If you want to count such rows only once, then this should work: =COUNTIF($G:$G,DATE(2050,1,1))+ COUNTIF($H:$H,TODAY())- SUMPRODUCT(--($G:$G=DATE(2050,1,1)),--($H:$H=TODAY())) Hope this helps getting started. |
All times are GMT +1. The time now is 01:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com