OK, good deal. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"kyoko" wrote in message
...
its ok now...sorry, i key in wrong data that's why it didn't apply
clearly..thanks a lot T. Valko...i appreciate your help!!thanks so
much..^_^

"T. Valko" wrote:

it's not so applicable

Why do you say that? You want to count for multiple conditions, don't
you?

im still having a problem with it..

Care to explain what that problem might be?

Maybe I've misunderstood what it is you want to do. My interpretation of
your post is you want to count based on conditions: dates that fall
within a
range of dates, % = -50% and text = cover. The formula I suggested does
exactly that. Based on your posted sample data my formula returns 2.

--
Biff
Microsoft Excel MVP


"kyoko" wrote in message
...
thanks for that but is there any other formula rather than that because
it's
not so applicable, im still having a problem with it..

"T. Valko" wrote:

Try this...

Use cells to hold the criteria.

E2 = lower date boundary = 10/27/2009
F2 = upper date boundary = 10/29/2009
G2 = -50%
H2 = cover

Then:

=SUMPRODUCT(--(A2:A7=E2),--(A2:A7<=F2),--(B2:B7=G2),--(C2:C7=H2))

--
Biff
Microsoft Excel MVP


"kyoko" wrote in message
...
i really need help for this one:

A B C
oct 27 -50 cover
oct 27 -50 not cover
oct 27 50 cover
oct 28 150 cover
oct 28 -100 cover
oct 29 -50 cover

in this case, i need the number of "cover" from oct 27 to oct 29
that
falls
under -50 only. is there any way to make it easier for me to get the
number
of it? please help me..i will appreciate it a lot..thanks in advance


.



.