Help with formula

[ShelRN]

Hello,

I have a range of items that I am trying to find an average for. Essentially, I need to find out that IF column A has a value of 1, then I want to take the number in column B and average it. 

[#2 · Accepted solution]

@ShelRN 

=AVERAGEIF($A$3:$A$25,A3,$B$3:$B$25)

Maybe with this formula which dynamically calculates the average for any value in column A. 

[#3]

That worked! Thanks so much, @OliverScheurich