I need help with an excel formula

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

I have a spreadsheet that I am trying to find a average of one column with several rows that if another column with several rows contains a certain word then I would get the answer

for ex
if c3:c37 contains "lot" then I want the average of v3:v37

Please help



1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
=AVERAGE(IF(C3:C37="lot",V3:V37))

invoke this formula with control shift enter

by chance you have hit enter key it will give wrong value. in such case select that formula cell , hit F2 and hit control shift enter.