LinkBack URL
About LinkBacks
use countifs
=COUNTIFS($C$6:$C$41,$A86,$I$6:$I$41,"buy")
=COUNTIFS($C$6:$C$41,$A86,$I$6:$I$41,"buy",$N$6:$N$41,"p")
=COUNTIFS($C$6:$C$41,$A86,$I$6:$I$41,"buy",$N$6:$N$41,"l")
use countifs
=COUNTIFS($C$6:$C$41,$A86,$I$6:$I$41,"buy")
=COUNTIFS($C$6:$C$41,$A86,$I$6:$I$41,"buy",$N$6:$N$41,"p")
=COUNTIFS($C$6:$C$41,$A86,$I$6:$I$41,"buy",$N$6:$N$41,"l")
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Hi Martin,
Thank you for the rapid and excellent response.
The formula works wonderfully.
Appreciate your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks