Hi
Does anyone know a sum for the attached, basically I want a sum that will show me
how many single people like icecream
how many married people like icecream
how many couples like icecream
Any help muchly appreciated ?
Hi
Does anyone know a sum for the attached, basically I want a sum that will show me
how many single people like icecream
how many married people like icecream
how many couples like icecream
Any help muchly appreciated ?
Maybe a PT:
or
=SUMPRODUCT(--($D$3:$D$10="single"),--($C$3:$C$10="yes"))
"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
Thanks Martin, if I were to pull the infor from another sheet on the workbook say for exapmple the sheet was called 'Q1 10-11' how would I include that in the sum ?
I tried =SUMPRODUCT(Q1 10-11'--($D$2:$D$100="Single"),--($C$2:$C$100="Yes"))
but this does not work ?any ideas ?
You don't need to type in.
Just select range you want to use.
So...
Copy/paste formula
Delete $D$3:$D$10
Select range
It works!!thanks guys !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks