Assuming your "hidden" weights for "No" in A2:A8
a 2;6;2;5;5;2;5
then this expression:
=SUMPRODUCT(--(A2:A8="No"),{2;6;2;5;5;2;5})
will return it
aloha? yes it below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Shevy" wrote:
Ok lets have one more go at this.... IF
A2 no (HAS VALUE OF 2)
A3 no (HAS VALUE OF 6)
A4 no (HAS VALUE OF 2)
A5 yes (HAS VALUE OF 0)
A6 no (HAS VALUE OF 5)
A7 no (HAS VALUE OF 2)
A8 yes (HAS VALUE OF 0)
So what I need to know is if you was answering these questions above how
would I be able to value the NO's with a different value?? So the total at
the bottom would add up all the values ofcourse ignoring the YES's as they
have zero value...
at present I have =COUNTIF(I14:I33,"NO") but that is counting NO as 1