Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 2nd 08, 06:46 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 47
Default add total only shaded cells

Hi everybody,

Can anyone help.
I have a formula that colors the cell which is less, how can I add only the
colored cells?

Example; Collumn "A" & Collumn "B" with 100 rows each, entered a formula
to highlight with a color the <cell. Is there a way to add the value of the
colored cell only?

Please help!
--
smile

  #2   Report Post  
Old December 2nd 08, 07:14 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2008
Posts: 703
Default add total only shaded cells

On 2 Dec., 19:46, israel wrote:
Hi

You can not sum by color, but you can use a sumif formula, and apply
the you used to color cells

Your formula could look like this:

=SUMIF(A1:B100,"<100")

Regards,
Per

Hi everybody,

Can anyone help. *
I have a formula that colors the cell which is less, how can I add only the
colored cells?

Example; Collumn "A" & Collumn "B" with 100 rows each, *entered a formula
to highlight with a color the <cell. *Is there a way to add the value of the
colored cell only?

Please help!
--
smile


  #3   Report Post  
Old December 3rd 08, 04:24 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 15,768
Default add total only shaded cells

Try this:

=SUMPRODUCT(((A1:A100<B1:B100)*A1:A100)+((B1:B100< A1:A100)*B1:B100))

--
Biff
Microsoft Excel MVP


"israel" wrote in message
...
Hi everybody,

Can anyone help.
I have a formula that colors the cell which is less, how can I add only
the
colored cells?

Example; Collumn "A" & Collumn "B" with 100 rows each, entered a formula
to highlight with a color the <cell. Is there a way to add the value of
the
colored cell only?

Please help!
--
smile





Reply
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
Shaded cells won't print shaded Linda C Excel Worksheet Functions 3 February 19th 17 11:41 PM
How do I get gridlines in shaded cells? Joemerald Excel Discussion (Misc queries) 1 February 13th 07 06:04 PM
linking shaded cells Roz Excel Discussion (Misc queries) 2 January 24th 07 04:39 PM
How do I count shaded cells Randy Excel Worksheet Functions 19 February 3rd 05 11:35 PM
Selecting shaded cells in a row Al Excel Worksheet Functions 5 January 25th 05 05:31 AM


All times are GMT +1. The time now is 09:14 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017