Quick Question

  • Thread starter Thread starter dpiekarz
  • Start date Start date
D

dpiekarz

Let say I have a spreadsheet like this
ColA ColB
One 1
Two 3
One 7
Two 3
One 4
Two 7

I would like to right a formula that averages all items in ColB wher
ColA of the same row is = to "One
 
Hi
one way:
enter the following array formula (entered with CTRL+SHIFT+ENTER)
=AVERAGE(IF(A1:A20="One",B1:B20))

or a non-array entered formula
=SUMIF(A1:A20,"One",B1:B20)/COUNTIF(A1:A20,"One")
 
Back
Top