I need help with an excel formula

Closed
mics - May 20, 2011 at 01:26 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - May 20, 2011 at 10:20 PM
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

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
May 20, 2011 at 10:20 PM
=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.
0