EXCEL formula IF
Closed
Mayra
-
15 Dec 2021 à 03:36
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 16 Dec 2021 à 12:21
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 16 Dec 2021 à 12:21
Related:
- Excel marksheet formula
- Grade formula in excel marksheet - Guide
- Formula to calculate vat in excel - 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
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
16 Dec 2021 à 12:21
16 Dec 2021 à 12:21
Hi Mayra,
So you basically want to count cells that contain data.
=COUNTIF(B2:B101,"*")
When the D.O numbers are located in range B2 to B101 and only 10 cells contain data, then the result of the formula above will be 10.
Is this what you are looking for?
Best regards,
Trowa
So you basically want to count cells that contain data.
=COUNTIF(B2:B101,"*")
When the D.O numbers are located in range B2 to B101 and only 10 cells contain data, then the result of the formula above will be 10.
Is this what you are looking for?
Best regards,
Trowa