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
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - May 20, 2011 at 10:20 PM
Related:
- I need help with an excel formula
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Transfer data from one excel worksheet to another automatically formula - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
May 20, 2011 at 10:20 PM
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.
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.
