try something like this. This is an array formula which must be entered
using ctrl+shift+enter.
=average(if(a2:a200=1,b2:b200))

--
Don Guillett
SalesAid Software

"Flutie99" wrote in message
...
I have some data that I like to select and deselect using 1 or 0,
respectively. I'd like to look at the average of the values of the
numbers I
select using 1. Essentially, I am looking for an "averageif" function.