bivek baskota
New Member
- Joined
- Feb 19, 2016
- Messages
- 2
how to add numbers which have same background color or font color?
how to add numbers which have same background color or font color?
=SUMIF(B2:B13,"Yellow",A2:A13)
try this
Code:=SUMIF(B2:B13,"Yellow",A2:A13)
=SUBTOTAL(109,A2:A20)
Hi,
Apart from using VBA, the only work-around I can think of is to use SUBTOTAL
Code:=SUBTOTAL(109,A2:A20)
Add the AUTOFILTER to the column header and filter by Colour (font or background)
"Subtotal 109" will add up the numbers displayed.
Paul.