Bernie, I tried the formula:
=SUMPRODUCT((A1:A100="no")*(B1:B100="down")*(C1:C1 00))/SUMPRODUCT((A1:A100="no")*(B1:B100="down")),
but I get an error message (#Div/0!). I don't know enough yet about pivot
tables to try this method, but I am working on it.