formula works for numb, but need "x"

[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

 

[Biff]

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