If and Sumproduct
Perfect! Thanks.
"PCLIVE" wrote:
May be this:
=SUMPRODUCT(--(E$1:E$250="Research"),--(C$1:C$250=K$1),--(C$1:C$250<=K$2))
"ronnomad" wrote in message
...
I have about 250 pieces of equipment that are serviced periodically every
3,
6 or 12 months. Each piece is located in a specific department and I want
to
identify the number of pieces serviced in a defined time frame by
department.
Column C contains service dates; column E contains the department names
and
all columns between A & E have headings. The other columns have info not
related to the query. K1 & K2 contain the beginning and end dates for the
query.
The formula I wrote:
=IF(E$1:E$250="Research",SUMPRODUCT(C$1:C$250=K$1 )*(C$1:C$250<=K$2),0)
returns the value of 0. What have I done wrong?
Thanks,
Ron
|