Hi

Can someone help me with the below query.

I have created two columns in excel (2003)

Columns 1: Has 4 options in a drop down list(Ex : option1, option 2, option 3, option 4)

Column 2: random Numbers including numbers less than 0

I would like to find the average ONLY if it satisfies both the below conditions

condition 1: If column 1 = "option1"

condition 2: if column 2 > 0

Can someone help me with a formula please?

## Bookmarks