it works!!! Thank you so very much.

"T. Valko" wrote:

Try this:

=SUMPRODUCT(--(A6:A99=10%),--(A6:A99<=25%),--(B6:B99="DS"))

--
Biff
Microsoft Excel MVP


"Laura" wrote in message
...
I am trying to use a countif formula to count column a - rows 6-99 if
between10%and 25% AND if column b =DS.

can you help - i have tried the sumproduct - might not have the right
formula to put in but I tried and i have tried the function and several
other
suggestions the help provided.

I would greatly appreciate it. Thanks