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
|