Скачать
COUNTIFS Filtered Data in Excel
Автор: Excel Universe
Загружено: 2021-02-14
Просмотров: 1976
Описание:
Query asked by Mr. Itesh Dhamne.
Questions:- I have all India state wise sale data. So I used COUNTIFS function then there showing all India count as per given conditions. Same thing in same data I required state wise. Like whenever I select location count the record particular state only as per condition.
Thanks to Mr. Vijay Gupta for helping him solve the question.
In this video I have explained in detail how we can do this, I have used #SUBTOTAL and #COUNTIFS function to solve this query.
Download Practice file here👇
https://mega.nz/file/trJmlByb#1rGIZif...
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
