EXCEL - Sum or Count Values based on CELL COLOR
ฝัง
- เผยแพร่เมื่อ 8 ก.ย. 2024
- Learn in 2 easy steps on how to create a new formula in excel to count or sum values, based on the cell colour.
Visual basic formula to add...
Module 1:
Function Cellcolor(rng As Range) As Long
Application.Volatile
Cellcolor = rng.Interior.Color
End Function
This Workbook:
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
Application.Calculate
End Sub
Check out my other playlists below:
PIVOT TABLES:
• Group & Ungroup date f...
EVERYTHING about the FILTER FUNCTION:
• EXCEL Filter Rows & Co...
EXTRACT first word, 2nd word, last word, numbers, letters:
• STOP Manually Extracti...
2 MINUTE Formula:
• Excel If formula - If ...
Thank you, subscribed, turned on notifications and liked 👍
Thanks for the comment... and all the extras. :)