Put an if statement inside an if statement

So instead of

=If(A1=1,235234,0)

you have

=If(A1=1,if(b1=3,5,4),0)

Which says......

If A1 = 1 And B1 = 3 put 5
If A1 = 1 And B1 3 put 4
If A1 1 then put 0

You can embed up to 7 levels of if.

Then sum and count.

If you have hundreds of combinations, look up pivot tables.

Posted By: BeverlyHills0201, Feb 22, 14:31:24