Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 11th 09, 05:11 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2009
Posts: 2
Default Sumif based on cell format

Is it possible to use Sumif based on the cell's format? For example, I want
to add up the numbers in a column that are highlighted green.

  #2   Report Post  
Old September 11th 09, 05:36 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 15,768
Default Sumif based on cell format

Not directly. You'd need some VBA procedures.

See this:

http://www.cpearson.com/Excel/colors.aspx

I recommend not doing it this way.

Write a formula based on the logic of *WHY* the numbers are highlighted
green. If they're highlighted using conditional formatting then you should
be able to write a formula based on the conditional formatting logic.

--
Biff
Microsoft Excel MVP


"Fun Dan" wrote in message
...
Is it possible to use Sumif based on the cell's format? For example, I
want
to add up the numbers in a column that are highlighted green.



  #3   Report Post  
Old September 11th 09, 06:40 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2006
Posts: 2,836
Default Sumif based on cell format

Find all colored cells and sum all:
Here is a quick way without VBA or formulas.
Edit Find clear "Find What" Options Format
"Choose Format From Cell" select sample cell
Find All scroll to end of list, press CTRL+SHIFT
and click on the last entry of the list.
Right click Status Bar and check Sum.

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"T. Valko" wrote:

Not directly. You'd need some VBA procedures.

See this:

http://www.cpearson.com/Excel/colors.aspx

I recommend not doing it this way.

Write a formula based on the logic of *WHY* the numbers are highlighted
green. If they're highlighted using conditional formatting then you should
be able to write a formula based on the conditional formatting logic.

--
Biff
Microsoft Excel MVP


"Fun Dan" wrote in message
...
Is it possible to use Sumif based on the cell's format? For example, I
want
to add up the numbers in a column that are highlighted green.






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
Sumif based on value in cell Jane Excel Worksheet Functions 4 April 23rd 09 03:19 PM
Sumif based on criteria on another cell Jane Excel Worksheet Functions 3 April 22nd 09 09:36 PM
SUMIF Based On Cell Color Mike Excel Discussion (Misc queries) 1 August 18th 08 11:02 PM
sumif based on cell comparison in excel Bunty Excel Worksheet Functions 2 November 13th 06 03:38 PM
sumif-add amount to another cell based on two criteria gabrielinlompoc Excel Discussion (Misc queries) 0 February 10th 06 12:22 AM


All times are GMT +1. The time now is 01:22 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017