Hi On a very much related theme (so forgive me if its stoopid!)

I have some data if this format

Type UK UL ON
RO True False False
RO False True True
SO True False False
POR False True False
SO False False False

I want a formula to allow me to calculate how often UK then UL then ON are
true for each group (RO, SO and POR) ie counting those in the UK column that
are true
only when type = RO

Can anyone help?


"Max" wrote:

Perhaps ..
Put in D1: =IF(OR(B1="",C1=""),"",IF(B1=C1,A1,0))
Copy D1 down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"michelle" wrote:
a b c d
1 .2 yes yes .3
2 .5 no no .5
3 .1 yes maybe 0

So, as in the above example, I need to put a formula in D1 so that it will
take the sum of column a if column b = c1. I hope this makes sense. And
keep in mind I will be continually adding rows to this and will need it to
cover the entire row, not just part of a row.

Thank you in advance and let me know if you need more clarification.