Free Microsoft Excel 2013 Quick Reference

HOW DO I COUNT CELLS OF A CERTAIN COLOR ONLY?

Having trouble counting cells in an excel spreadsheet that have a certain
color only. Can anyone help?


Post your answer or comment

comments powered by Disqus
How do I select all (of a certain string) and also the 2 cells to the right of those selected, then put them all in a text file in 3 columns ?

I am creating rosters of students and would like to find out two things:

How do I count all of the cells that are filled in (omitting those that are
empty)?

I'm integrating information from another system that is not compatible, so I
would like to eliminate the duplicated student names monthly. Is there a way
to use the COUNTIF function to "throw out" names so that I count each student
only once?

Thanks

in Excel, how do I convert sin of a number to degress

How do I count number of cels the matches 2 conditions (I am using COUNTIF
and AND) ??? I need the total of cels that matches the 2 conditions and not
the sum of the cels.
Thanks

Hi, I am trying to create a macro that will clear data from all cells of a certain color (yellow) in the current worksheet.

If possible, it would be helpful to see a variation of the solution that performs the same task across all sheets in the workbook.

I am unfamiliar with VBScript so I would appreciate it if the solution could posted in a format that can be easily copied and pasted (without requiring complete understanding of the script itself. )

Any help truly appreciated!

----
Thanks,
Mike

Is there a way to create a formula that would enter in a certain cell the sum of all the numbers in cells of a certain color?

For example, have the sum of all Red cells in sheet 1 in cell A1 of sheet 2, sum off all Blue cells in sheet 1 in cell A2 of sheet 2, etc...

I can't figure out how to count occurrences of a wildcard matching certain
criteria. For example, let's say I want to count the number of cells
containing words ending in "ing" - even if those cells contain other words
besides the one ending in "ing". How do I do that? And then, out of that
count, how do I count only the number of those cells which also contain a
value of "X" in the same row one column to the right? Let me give a visual:

A B C
1 slow ending X
2 slow beginning X
3 fast ending

In this example, there are 3 cells in column A that contain a word that ends
in "ing", and out of those 3, 2 of them have an X in column B. What formula
would I use in this situation to account for the wildcard *ing, and to count
only those occurrences that also have an X in column B, to give the value of
2 in the cell containing this formula?

I can't figure out how to count occurrences of a wildcard matching certain
criteria. For example, let's say I want to count the number of cells
containing words ending in "ing" - even if those cells contain other words
besides the one ending in "ing". How do I do that? And then, out of that
count, how do I count only the number of those cells which also contain a
value of "X" in the same row one column to the right? Let me give a visual:

A B C
1 slow ending X
2 slow beginning X
3 fast ending

In this example, there are 3 cells in column A that contain a word that ends
in "ing", and out of those 3, 2 of them have an X in column B. What formula
would I use in this situation to account for the wildcard *ing, and to count
only those occurrences that also have an X in column B, to give the value of
2 in the cell containing this formula?

I have a row of cells, some with data and some blank. How do I count the
number of blank or non-blank cells and display the total in a cell?

Using a CountIf formula, how do I count the number of cells in a range of
cells that have a value greater than and less than two specified number, i.e.
0>=x<=17?

Hi,
I could use some help with this one.

I have a horizontal list of numbers that represent values for weeks 1 to 52. I know how to figure out the highest week's value (using the max formula) but don't know how to figure out what week it happened in. ie: I know in week 23 I had my highest number, but how do I write a formula that counts to the max value and tells me it's number 23????
If anyone can help me figure this out, I would greatly appreciate it.
Thanks

Hi all,

I have accidently hit the window then new window menu item how do I get rid of the 2nd window this is easy and I have done it before memory is a blank

Thanks in anticipation.

Phil

I have a black box that shows up when I try to print an excel worksheet that
was sent over as an attachment. How do I get rid of it?

How do I count the number of times a particular charcter ("." say) appears in
a cell.

For example, ABC.1.21.31.2 should retun 4.

Is there a formula?

How do I count the number of times a particular charcter ("." say) appears in
a cell.

For example, ABC.1.21.31.2 should retun 4.

Is there a formula?

I have a list of countries and each county can be of a certain category (rehab, end user.. etc (there are 5)
I want to have a counter to count the value of type (ie "rehab") if the cell containing country is of type x (ie albania).

Please help

I have a class list in Excel.
About half of the class are seniors the others juniors. In the fist colomn there's a number(1-27) the second colonm is the rank(senior or junior) and the third colomn is the attendence for a single day(sept. 13) . What formula would i use to calculate how many seniors and how many juniors have attended on a certain date. I need these numbers separately, seniors in one cell and juniors in another.

Maybe there's a way to do it simpler in Access... any ideas?

Thank you in advance

Could someone kindly help me with this problem.

Two Columns, Column 1 is filled with references (in text), and column 2 with descriptions, how do I count the no. of different descriptions in Column B of the same reference from Column A irrelevant of it being in capitals:

eg.

1 2
A bag
A bag
B Piano
A BAG
B Jumper
A car
B piano

A would be 2 (i.e. 2 different descriptions Bag and Car)
B would be 2 (i.e. 2 difference descriptions Piano and Jumper)

Many thanks

I'm using XP SP2 and Microsoft Excel 11.0 8105 SP2.

After hours of searching and tweaking I give up.

=SUBTOTAL(3,B4:B5000)

The above works fine if placed in a cell but I can't get the same
results in VBA.

These don't work:

X = Application.WorksheetFunction.SUBTOTAL(3,B4:B5006)

X = SUBTOTAL(3,B4:B5006)

I want to use the row count to set the high limit of a FOR loop as the
filter changes the record count.

How do I count the number of filtered rows?????????

Thanks for any Help, Rick

I collect stats for a sports team, and the sheet used tracks Goals (G),
Assists (A) and Shots (I) all in the same cell, with one cell per period.
What I need to be able to do is track the number of times a "G" comes up in a
period for a team, as well as over all the periods of the game for the
specific player. COUNT seems to be all-or-none for the entire cell (match or
doesn't match), while FIND/SEARCH only returns the first incidence of the
character (so if two goals are scored by the same player in the same period,
only the first gets recorded)

So, If I were to use the following data list, what could I put at "the
bottom" in order to give a Goals Total for that period?

AA
GGI
G
IG
A
A

Please & Thanx!
- Jason

Hi,

I need to count the total of characters in a cell.

How do i count character in cell?
For example:
I have in the cell A1, the text ¨Me gusta mucho la tecnologia¨ the sum of
character is 28, and i want this number in cell B1.

Thanks
Angie

When I use the superscript option after selecting just a portion of the cell,
the superscript appears during edit mode only. How do I get it so it appears
as superscript on the spreadsheet or when printing? Again, I'm only trying
to superscript part of a cell's contents, not the entire cell.

I'm using the new Office 2004 for the Mac and first, I hate it! But, how do I
get rid of the green (warning?) triangle in the cells. I haven't entered a
equation and I have no idea where it came from. Please help.

Hi,

I need to count the total of characters in a cell.

How do i count character in cell?
For example:
I have in the cell A1, the text ¨Me gusta mucho la tecnologia¨ the sum of
character is 28, and i want this number in cell B1.

Thanks
Angie


No luck finding an answer? You could always try Google.