In my spread sheet I want to count the values of green, red and blue
background cells separetly, which are in a same row? i.e. I want excel to
only pick green cells and ignore others when counting the values. Does anyone
used this type of fuction before? I was thinking to use ...

i have to import a csv file into excel on a regular basis. The file contains
some data that are dates. For some reason excel insists on converting some
of the dates into m/d/y  format rather than d/m/y.
I cant figure out why.  Any clues anyone?   does anyone have a way of

On Sheet 1, I want to put a formula in ColA that tells the number of times
ColB occurs in Sheet 2, ColA. THANKS!
Sheet 1                                           Sheet 2
ColA        ColB                                 ColA

I have a if function =IF(SUM(F10:F52)=GM!$B$21,GM!$B$21,"wrong sum").
This looks up the some of one sheet and compares it to another to see if
they are the same. To come up with a sum I have different qty's of units.
Some times w. qty of 2 it works but w. qty of 3 it doesn't. 9 ...

There is a facility within Excel xp whereby when a group of cells is
highlighted (click and drag) the sum of those cells is shown in the bottom
right hand corner of the screen (off worksheet).
Hope I've made myself understood.   Anyway, now it's gone!   I must have

Is it possible to create a workbook within a workbook?

Is it possible to make Array References dynamic?
For example I have a formula which is something like this:
=VLOOKUP(A1, [excelFile.xls]*sheetTab*!A1:C10, 2, FALSE)
Is it possible for the value of *sheetTab* in above to depend on the

i am trying to enter my work hours an payday on a calander i downloaded from
excel but i can only enter one or the other not both please help i am just
learning about excel

I have a large table of data which, based on the SUM formulae I have put
in for some columns, apparently have been mis-keyed with 3 decimal
places, instead of only 2. I need to find out which values have 3
decimal places so I can correct them. Suggestions? Will a formula,

I am trying to change the color of a cell in Microsoft Excel, and it will not
change i've tried clicking on the fill color button and i've tried formating
the color with the toolbar.  Could someone please help me fix this.  It did
work, and i'm thinking that i changed a Setting ...

Using EXCEL 2000, I need the COUNTIF function when I want 2 conditions in
separate columns to be counted.

I have the current formula:
=SUMPRODUCT(--($A$1:$A$2500="CLE"),--($B$1:$B$2500="IE"),--($E$1:$E$2500=6),--($I$1:$I$2500<0))
which works perfectly.  Now I want to find out the number of times a value
less than 20% appears in column J.  Why won't this work when I change the

Once you delete all macros, how do you stop the macro prompt during file open?

I have the Simple Regression Function using one X-axis. I need the Multiple
regression function that uses two or more A-axis. I have Excel 2003. The
multiple regression is not shown on the task menu. How can I get it? thanks

I am trying to "sum" a column using "sumif" ... but need to use 2 criteria.
I have tried the Sumif(And(< cond 1 >,> cond 2 >)(ans) but this does not work.
Has anybody any idea how write the correct statement