LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 11th 20, 05:05 PM posted to microsoft.public.excel.misc
external usenet poster
First recorded activity by ExcelBanter: Sep 2011
Posts: 9
Default Summing cells of a unique color

Tried to use Help for this and got nowhere.

Office 365 Excel:

I have a column of cells that I have colored a background cell
color (blue) when they meet a simple criteria. I color them when
I enter the dollar amounts in the workbook.

I want to sum these colored values with the blue background and
only these values. (FWIW, about half the values in the column
have the colored background. The other cells are uncolored.)

How do I accomplish this? What conditions do I apply?

Thanks in advance for your help.

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Function for summing or counting cells based on a specified fill color shriil Excel Worksheet Functions 3 March 2nd 13 06:02 AM
Summing Cells by Color Dtemp Excel Discussion (Misc queries) 5 July 2nd 08 03:35 PM
Color Cells Summing HANYANA Excel Worksheet Functions 29 January 10th 07 03:16 AM
Summing Cells with a BLUE font (or any other color) RAYMOND KELLY Excel Programming 2 September 24th 04 06:59 PM
Counting/summing cells based on background color Nan[_2_] Excel Programming 2 May 11th 04 05:36 PM

All times are GMT +1. The time now is 11:58 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017