Remember Me?

#1
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
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
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
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
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
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---

"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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Jane Excel Worksheet Functions 4 April 23rd 09 03:19 PM Jane Excel Worksheet Functions 3 April 22nd 09 09:36 PM Mike Excel Discussion (Misc queries) 1 August 18th 08 11:02 PM Bunty Excel Worksheet Functions 2 November 13th 06 04:38 PM gabrielinlompoc Excel Discussion (Misc queries) 0 February 10th 06 01:22 AM

All times are GMT +1. The time now is 08:57 AM.