I need help with an excel formula
Closed
mics
-
20 May 2011 à 13:26
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 20 May 2011 à 22:20
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 20 May 2011 à 22:20
Related:
- I need help with an excel formula
- Formula to calculate vat in excel - Guide
- Grade formula in excel marksheet - Guide
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel mod apk for pc - Download - Spreadsheets
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
20 May 2011 à 22:20
20 May 2011 à 22:20
=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.
