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
- 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
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
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