New Excel Forum
This forum has been moved to TeachExcel.com
Ask all future questions in the New Excel Forum.
ExcelKey
|
|
Unlocking the Mysteries of Excel
|
Summing Up Conditional Cells
2 posts
• Page 1 of 1
Summing Up Conditional Cells
by Alex G » Fri Dec 30, 2011 1:11 pm
I have a spreadsheet with some cells under a certain color coat conditional formatting. I do I setup to sum up the number of cells that meet that condition.
- 0
- Alex G
- Rookie
- Posts: 1
- Joined: Dec 30, 2011
- Reputation: 0
Re: Summing Up Conditional Cells
by Sisyphus » Fri Dec 30, 2011 9:00 pm
Hi,
Use the SUMIF() function and make the condition the same as you use for coloring the cells.
Use the SUMIF() function and make the condition the same as you use for coloring the cells.
- 0
Have a great day!
Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)
Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)
- Sisyphus
- Former Moderator
- Posts: 4454
- Joined: Dec 7, 2011
- Location: Shanghai
- Reputation: 203
- Excel Version: 2010
2 posts
• Page 1 of 1
Return to Macros and VBA Questions
Who is online
Users browsing this forum: Google [Bot], Majestic-12 [Bot] and 230 guests