Маълум бир рангдаги ячейкалар суммасини аниқлаш формуласи.
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
You can’t. What you can do, though, is use WhatsApp’s and Telegram’s web platforms to transfer stickers. It’s easy, but might take a while.Open WhatsApp in your browser, find a sticker you like in a chat, and right-click on it to save it as an image. The file won’t be a picture, though—it’s a webpage and will have a .webp extension. Don’t be scared, this is the way. Repeat this step to save as many stickers as you want.Then, open Telegram in your browser and go into your Saved messages chat. Just as you’d share a file with a friend, click the Share file button on the bottom left of the chat window (it looks like a dog-eared paper), and select the .webp files you downloaded. Click Open and you’ll see your stickers in your Saved messages chat. This is now your sticker depository. To use them, forward them as you would a message from one chat to the other: by clicking or long-pressing on the sticker, and then choosing Forward.
How Does Bitcoin Work?
Bitcoin is built on a distributed digital record called a blockchain. As the name implies, blockchain is a linked body of data, made up of units called blocks that contain information about each and every transaction, including date and time, total value, buyer and seller, and a unique identifying code for each exchange. Entries are strung together in chronological order, creating a digital chain of blocks. “Once a block is added to the blockchain, it becomes accessible to anyone who wishes to view it, acting as a public ledger of cryptocurrency transactions,” says Stacey Harris, consultant for Pelicoin, a network of cryptocurrency ATMs. Blockchain is decentralized, which means it’s not controlled by any one organization. “It’s like a Google Doc that anyone can work on,” says Buchi Okoro, CEO and co-founder of African cryptocurrency exchange Quidax. “Nobody owns it, but anyone who has a link can contribute to it. And as different people update it, your copy also gets updated.”
