View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default HELP! Using IF, AND, OR and COUNTIF in one formula

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