How To Count Colored Cells In Excel - Full Guide
HTML-код
- Опубликовано: 23 июн 2024
- Learn how to . For more videos like this then please leave a like.
Custom function / formula
Function COUNTCOLOR(RANGE As Range, COLOR As Range)
Dim COLORC As Integer
Dim COUNTT As Integer
COLORC = COLOR.Interior.ColorIndex
Set IC = RANGE
For Each IC In RANGE
If IC.Interior.ColorIndex = COLORC Then
COUNTT = COUNTT + 1
End If
Next IC
COUNTCOLOR = COUNTT
End Function
GuideRealm is the home of technology-based how-to's, guides & tips
Equipment & tools I use (affiliate links):
Tubebuddy (RUclips tools): www.tubebuddy.com/pricing?a=T...
Microphone: amzn.to/3IQgsiH
Laptop: amzn.to/3ITBwom
PC: amzn.to/3MPNgJL
Some of the links in this description are affiliate links. As an Amazon Associate and a partner of other affiliate programs, this means I will earn a small commission from qualifying purchases through these links.
Please like, subscribe, and comment.
GuideRealm - Хобби
First
Bad. Video