Countif or other formula needed for multiple data/critera results


C

cdmartin

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 o
1/1/2050, and a count for Column H that is equal to today()
 
Ad

Advertisements

C

Claus Busch

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.
 
Ad

Advertisements

M

MyVeryOwnSelf

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top