EXCEL formula IF
Closed
Mayra
-
Dec 15, 2021 at 03:36 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 16, 2021 at 12:21 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 16, 2021 at 12:21 PM
Related:
- EXCEL formula IF
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel apk for pc - Download - Spreadsheets
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Dec 16, 2021 at 12:21 PM
Dec 16, 2021 at 12:21 PM
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