Can I use a Reference inside a SUMIF or COUNTIF Function?
You're welcome. Thanks for the feedback!
--
Biff
Microsoft Excel MVP
"Laura" wrote in message
...
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
|