Маълум бир рангдаги ячейкалар суммасини аниқлаш формуласи.
Excel таркибида афсуски бу формула мавжуд эмас, лекин уни макрослар ёрдамида яратиб олишимиз мумкин. Бунинг учун:
1️⃣ Янги файлни xlsm форматида сақлаб олинг. 2️⃣Alt + F11 бирикмасини босиб янги Модуль яратинг. 3️⃣ Қуйида кўрсатилган кодни кўчириб олиб модульни сақланг. 4️⃣ Формулани ишлатиш учун иккита критерий белгиланг: диапазон ва рангли ячейка. 5️⃣ Формула ҳисоблаши учун F9 клавишасини ишлатинг.
Public Function SummaRang(DataRange As Range,ColorSample As Range) As Double Dim Sum As Double Application.Volatile True
For Each cell In DataRange If cell.Interior.Color = ColorSample.Interior.Color Then Sum = Sum + cell.Value End If Next cell SummaRang = Sum End Function
Маълум бир рангдаги ячейкалар суммасини аниқлаш формуласи.
Excel таркибида афсуски бу формула мавжуд эмас, лекин уни макрослар ёрдамида яратиб олишимиз мумкин. Бунинг учун:
1️⃣ Янги файлни xlsm форматида сақлаб олинг. 2️⃣Alt + F11 бирикмасини босиб янги Модуль яратинг. 3️⃣ Қуйида кўрсатилган кодни кўчириб олиб модульни сақланг. 4️⃣ Формулани ишлатиш учун иккита критерий белгиланг: диапазон ва рангли ячейка. 5️⃣ Формула ҳисоблаши учун F9 клавишасини ишлатинг.
Public Function SummaRang(DataRange As Range,ColorSample As Range) As Double Dim Sum As Double Application.Volatile True
For Each cell In DataRange If cell.Interior.Color = ColorSample.Interior.Color Then Sum = Sum + cell.Value End If Next cell SummaRang = Sum End Function
In recent times, Telegram has gained a lot of popularity because of the controversy over WhatsApp’s new privacy policy. In January 2021, Telegram was the most downloaded app worldwide and crossed 500 million monthly active users. And with so many active users on the app, people might get messages in bulk from a group or a channel that can be a little irritating. So to get rid of the same, you can mute groups, chats, and channels on Telegram just like WhatsApp. You can mute notifications for one hour, eight hours, or two days, or you can disable notifications forever.
Find Channels On Telegram?
Telegram is an aspiring new messaging app that’s taking the world by storm. The app is free, fast, and claims to be one of the safest messengers around. It allows people to connect easily, without any boundaries.You can use channels on Telegram, which are similar to Facebook pages. If you’re wondering how to find channels on Telegram, you’re in the right place. Keep reading and you’ll find out how. Also, you’ll learn more about channels, creating channels yourself, and the difference between private and public Telegram channels.
