Previous Topic Next Topic

I need help with an excel formula

Closed
mics - May 20, 2011 at 01:26 PM
venkat1926 Posts 1863 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



Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response