gREAT THANK YOU VERY MUCH, WORKED PERFECTLY BUT TURNS OUT IT WAS THE SECOND
SUGGESTION THAT DID IT, MUST HAVE BEEN BOLLEAN TRUES

"David Biddulph" wrote:

Perhaps =SUMPRODUCT((A2:A6="RO")*(B2:B6="True")) or
=SUMPRODUCT((A2:A6="RO")*(B2:B6=TRUE)) ?

Make sure you distinguish between the text string "True" and the Boolean
value TRUE.
--
David Biddulph

"mark" wrote in message
...
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.