Sorting according to formatted cells.
Posted by Robert on October 18, 2001 6:33 AM
Here's the problem:
I have 3 Columns which I have conditionally formatted. Another column contains text (names). In addition to these 4 Columns there are about 15 other columns that contain number data that must be sorted according to the cells I have formatted and the text. These columns have numbers in them and I would like to sum these numbers according to the rows which match text and formatted criteria.
Any help would be appreciated. Thanks
Posted by Robert on October 18, 2001 7:47 AM
COUNTIF multiple conditions (more info)
If the problem can not be solved by counting according to formatting, I would like to know if I can COUNTIF for the multiple conditions. The spreadsheet is set up as follows. Column C, G, and I have numbers. I have conditionally formatted the columns so that cells in Column C less than or equal to those in columns G and I are highlighted. Cells in column G are highlighted if they are less than those in column C or less than or equal to those in column I. Cells in column I are highlighted if they are less than cells in columns C & G. Column N contains a list of text names. Column O contains text. I need to count the number of occurances of certain text in column O with respect to the names in column N and what cell is highlighted in C,G, or I for each row.
I hope someone can help. Thanks.
Posted by Aladin Akyurek on October 18, 2001 8:20 AM
Mukticonditional count
Robert,
You've got pretty complicated set of conditions.
I'd suggest to create additional columns to process C, G, and I such that in the column next to C I'd enter the formula for contional formatting that you used to highligh C-cells as follows:
=the-formula-you-used+0 [ this produces either 1 or 0 ]
The same logic applies to the columns that should process "highlighting" of G and I respectively.
After all this, you might want to use SUMPRODUCT function to do the counting job. You can find lots on multiconditional count by a judicious search on this site. One easy way to do that search is:
---------
To search MrExcel a little easier, go to www.AllTheWeb.com and change the language option to english. Type in Mrexcel followed by the subject of what your looking for, i.e.:
mrexcel formatting
That should return pages from mrexcel's message board (archive or not), or if it only returns one, there should be the option for "more pages like this" which will return info from the message board specifically...
Cory
----------
Aladin
Posted by Robert on October 18, 2001 8:41 AM
Re: Mukticonditional count
Thanks, I was wondering how to search the site. Thanks for the suggestion.
