formula works for numb, but need "x"

  • Thread starter Thread starter Annette
  • Start date Start date
A

Annette

This works for numbers, but I need it to work for counting X.

=SUMIF(DInput!$A$2:$A$2500,">="&B3,DInput!$C$2:$C$2500)-SUMIF(DInput!$A$2:$A
$2500,">"&C3,DInput!$C$2:$C$2500)

(I'm looking at dates in there ... counting the number of X in a column for
one month. Col 1 has the date, column C has the X's ... sheet two(total) has
the above formula with date range specified in column B3 - C3 for each
month)

Hope this makes sense.

Thanks for your help.

Annette
 
Hi Annette,

It's not exactly clear what you want to do. If you want to
count the total number of X's that meet the 2 different
conditions:

=SUMPRODUCT((DInput!$A$2:$A$2500>=B3)*(DInput!
$C$2:$C$2500="X"))+SUMPRODUCT((DInput!$A$2:$A$2500>C3)*
(DInput!$C$2:$C$2500="X"))

Biff
 
Back
Top