Log In
Create Account
SlickerTalk
Search Archives
The Leaderboard
The FAQ
Login
Create Account
Search
Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...
RSS Feed
Hosting by DigitalOcean
Support ST on Ko-Fi
Links Only
50 Results
100 Results
250 Results
500 Results
1000 Results
5000 Results
2 Weeks
2 Months
6 Months
1 Year
2 Years
5 Years
All Time
Live
Down to Post
Backboards:
Live
________________
1: Nov 28, 16:19
2: Nov 28, 09:42
3: Nov 27, 18:07
4: Nov 27, 12:04
5: Nov 27, 08:26
6: Nov 26, 18:06
7: Nov 26, 12:05
8: Nov 26, 08:29
9: Nov 25, 18:33
10: Nov 25, 11:12
11: Nov 25, 07:08
12: Nov 24, 13:17
13: Nov 23, 18:13
14: Nov 23, 06:17
15: Nov 22, 13:24
16: Nov 22, 09:09
17: Nov 21, 22:36
18: Nov 21, 14:03
19: Nov 21, 10:18
20: Nov 21, 07:35
Posts: 156
excel help - is there a way to sum up amounts that are in specific colored cells?
Posted by
tRuMaN (aka tRuMaN)
Dec 1 '21, 12:47
like all the Yellow cells
or the Blue cells?
Responses:
You can filter by cell colour and then add that. -- nm
-
LMS
Dec 1, 16:10
Is this a one-off need or something ongoing?
-
Fuzzy
Dec 1, 13:10
1
one off. I just did the filter by color, it works, just wasnt dynamic for when I changed the colors as I sorted through things. -- nm*
-
tRuMaN
Dec 1, 13:37
Short of coding a VBA macro to do it for you, I’ve got nothing. -- nm*
-
znufrii
Dec 1, 13:02
you could directly reference the cell. Or are they colored conditionally? -- nm
-
loosilu
Dec 1, 12:50
5
As far as I know there is no way to use the color in a formula. But I did find this hack:
-
loosilu
Dec 1, 12:52
4
dang, nice -- nm
-
colinberry sauce
Dec 1, 13:13
That’s a lot better than what I would have put together. -- nm
-
znufrii
Dec 1, 13:11
that's pretty slick -- nm
-
prayformojo
Dec 1, 13:06
1
I'm not a fan of the typing. -- nm
-
loosilu
Dec 1, 13:19
Post a message
top
Replies are disabled on threads older than 7 days.
