Excel formula tutorial: How to use COUNTIF

preview_player
Показать описание
How to use Microsoft Excel 2013 COUNTIF. This video does apply to lower versions of Excel. This video will educate you on the basics of how to use the statistical function COUNTIF. The syntax of COUNTIF is =COUNTIF(Range, Criteria). Watch the quick video for an example of how to use.
Рекомендации по теме
Комментарии
Автор

Very plz send me exact formula ....which keys u used .thanku

maliksherry
Автор

I followed what you wrote but my count does not match the words written on column. I have category called Sporting Goods (written as that) and have those words listed twice. The function gives me 1 time. Where did I do wrong? I changed the COUNTIF to COUNTIFS to see that fix but nothing changed. So, I am asking maybe you can see where I did wrong

snip-sniptear