sumproduct

  • Thread starter Thread starter Graham
  • Start date Start date
G

Graham

I have a small problem I am sure is easily resolved ..


I am counting entries on a worksheet based on the
following
:=SUMPRODUCT((A1:A30>E1)*(A1:A30<F1)*(B1:B30="Bob"))

E1 + F1 being a date

the problem is that in A1:A30 there are discrepancies
i.e. text entered rather than data . Is it possible to
simply ignore a cell if it has text entered or do I need
to discipline peolple a little harder ??


Thanks in advance.
 
If you use SUMPRODUCT's comma syntax, it ignores non-numeric entries:

Try:

=SUMPRODUCT(--(A1:A30>E1),--(A1:A30<F1),--(B1:B30="Bob"))
 
Back
Top