Can someone please help with a formula for multiple cells. I am doing
inventory. I need to multiply quantity (column g) times cost (column k) to
equal in column m. I have been entering the formula singlely for each cell
but it is time consuming. I know there is an easier way, ...

I am trying in vain to incorporate an If Then Else into a macro; the basis
is as follows
Sheet Name = 'Search'
If  -Cells in the ranges (B5:F5) AND (B8:F8) AND (C8) AND (F9) = ""

What is the correct formula if I want to find the average for numbers that
are in multiple ranges and I don't want to count empty cells in those
multiple ranges? For example: my numbers are in ranges A4:A11 and A16:A23 and
A30:A44. Keep in mind that some of the cells in those ...

I am using a =sumif formula that is reading information from a source sheet.  
So, if I insert a line on row 64 it calculates that if the information in the
range onthe source sheet matches that in cell a on the worksheet, then it
should take the figure from the source sheet that ...

I have a spreadsheet that holds design proiducts that have been or need to
be closed out.  I'm looking to count the number of days these taken to close
by subtracting the date opened from the date closed or for the currently open
ones subtracting todays date from the date opened.

I apologize in advance for my naiveté..
I have a datalist in one worksheet that contains data associated with a list
title.  The list is contained in a 2nd worksheet.  I'm looking for a way to
replace the list title with all the entries that compile that list.

I have 2 macros A and B say and two buttons Cand D on a worksheet. Can I
have button C run Macro A and then at the end of the code make C invisisble
and D visible. Then have button D run Macro B and at the end of the code
make C visible and D invisible - am I making myself clear?

My mate sends me lists of mp3 files every so often. But he doesn't keep new
ones seperate. How can I tell excel to compare both lists and put the
discrepancies into a new column.
Cheers

Well i am trying to develop a excel
the following are the data
232=t
323=t

How to check if there is empty cell in a range by using IF Statement ?
I used to use IF Statement to detect empty cell within a range as EXAMPLE
listed below. It works in the past but suddenly fails and output "#VALUE".
Why ?

I would like to set a password to certain group of people in order for them
to modify the related column.  Means that Group A only allow to modify the
data in Column A-C, Group B only allow to modify the data in Column D-F,
otherwise only able to view, is there anyone can advise ...

I've now managed to get the first row in a worksheet to perform the
conditional formatting I want. But I'm having tourble trying to extend the
formatting to cover the whole spreadsheet. The Format Painter doesn't seem to
do the trick. I keep ending up with the whole spreadhseet ...

On a spreadsheet we have a column which simply has the answer Yes or No.
In a row where the answer in that column is "Yes", I'd like the first 2
columns to turn green.
Any ideas, please?

Column A holds "X" or "" (blank).  Column B holds "1", "2", or "3".  
I need to count the number of 1s, 2s, and 3s, in column B when the cell in
column A is blank.
I've tried several variations of IF, AND, & COUNTIF - can't get anything to

Kindly note that to prepare excel invoices daily. I have to write the total
amount of invoice both in figures and words, right now i m manually writing
the amount in words. Is there any formula to convert the figures to words?
I had also used the command i.e. spellnumber(..) but ...