I need help with an excel formula [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
798
=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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!