I have a to make a x,y-plot, where there in the reference area is not at
corresponding y-value after certain x value – the x value where the
calculation stops is variable and depending on other things. Because there in
the y-cells is a formula that is said to give "", when the ...

I would like to be able to count the number of females with a score in C.
so using Countif how do I say countif B = F and C equals a number?
I'd be grateful for any ideas how to do this.
Could I use Sumproduct as an alternative to countif?

I recieve income on the 1st and the 15th of every month, regardless of
the month, or day.
Understanding the serial number feature of Excel, I cannot create a
autofill that will fill in the 1st and 15th of every month.

Hi please help me in solving the following issue
e.g i have the follwoing date in Excel Sheet
   A        B        C        D        E
1 Jon     123

I have created a validation list True, False.
I would like to have blue color appearing in back ground whenever i select
"True" and Red color whenever i select "False"

i need a hand with a sumif function.
i am trying to sum where ever i see the word "Super" in column E and then
sum the $dollar values in the column c of the same rows.
Is this possible? i am having some problems with the formula.

I have a spreadsheet where I have certain tasks that must be performed
sequentially based on the main task of doing a particular job.  If the job
happens on the weekend, I need the formula to automatically recognise that it
is a weekend and allocate the next working day.  (I have ...

I have a file developed in Excel 2003 that I brought up in Excel 2007, to
confirm functionality.  Everything worked fine, but when I went to save the
file the compatibility checker reported "minor loss of fidelity" due to the
following:

I have a large file with a lot of links to other files.
All of them change twice a year. I copy all the files to a new folder,
rename them (all files begin with the year number) and manualy change
the links thru /edit/links

I have a random number generator between 81-88 which produces a new value
each time excel calculates.  
I would like to count each time the value of the previous number generated
and the new number passes by a current value. Say 81.5.  Here's my

Using the default color palette in Excel, I proceeded to format my latest
spreadsheet. Once completed, I saved the file. The next day, I opened the
previous file and also opened, in the same session, another older file that
had a modified color palette. When I viewed the new file ...

How do I convert a Lotus 123 into Excel?  My husband uses 123 and wants to
move some his old 123 programs into Excel without re-entering all of them.  
The 'Save as' doesn't work because the program won't open a 123 file I'm
trying to import.  

I am have my users navigate to several workbooks for importing data. I would
like to work it so that they can do the navigation, store the path and
filename, then subsequently do the actual file manipulation.
I use the following code to access the fn & Path:

I am trying to look up UPC values in column B.  If a UPC listed in Column B
is also listed anywhere in Column C, then I want to return 'Yes" in column D.
If not I want to return 'no".   I am sure this is simple, but I can't figure
it out from Lookup help.  Thanks!

I am making a billing system which will pick product prices automatically
from a price list of products.  My prices should change automatically
according to latest price. I have products like this
column A        column B               column C