This should do it (if I understand correctly what the OP wants):

=SUMPRODUCT((A1:A100)*(B1:B100+C1:C1000))

Hope this helps.

Pete


On Jan 29, 3:04*pm, Pete_UK wrote:
Yes, you're right, David - back to the drawing board !!

Pete

On Jan 29, 2:18*pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:



Wouldn't that count double if B and C were both true?
--
David Biddulph

"Pete_UK" wrote in message

...
Suppose your range covers rows 1 to 100. Then you would have something
like this:

=SUMPRODUCT((A1:A100)*((B1:B100)+(C1:C100)))

* is equivalent to AND, + is equivalent to OR. The assumes the cells
contain TRUE or FALSE.

Hope this helps.

Pete

On Jan 29, 12:50 pm, cydkil wrote:

I have not been able to get this to display results.

Here is what I am trying to calculate:

IF (A=True) AND (B=True or C=True) then count the occurences of A within a
range- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -