14.SUMPRODUCT to count non blank cells || Application of converting TRUE/FALSE into 1/0.

preview_player
Показать описание
This Video will show how to use SUMPRODUCT formula to count non blank cells in excel. We will compare COUNTA vs SUMPRODUCT and offcourse, SUMPRODUCT wins the race.

Please LIKE||SHARE||COMMENT||

Subcribe to my YouTube Channel:
Add me on FaceBook:
Like my FaceBook page:
Follow me on Google Plus:
Follow me on Twitter:
Add me on LinkedIn:
Рекомендации по теме
Комментарии
Автор

nice and good explained. but please all practiced files in the description....

ubaidillahmuhammad
Автор

what if my data is not numbers but text

hzwnnzm