Hi, Please help me to solve my problem: A1*A2*A3=A4 If the number for A1=2, A2=3, A3=0, then A4 answer will be zero.

Hi, I am trying to lookup & match a table of data from 2 different sheets. (meaning if sheet 1-Name,price, colour is equal to sheet 2-name,price,colour) Once...

Hey everyone: Excell 2007 on Vista This one is getting to me and I"m hoping you can help. My current data layout: Col C Col G Col E Florida...

I would kike to calculate the average in a column if it meets a criteria in another column. I have tried Average(if(....... this is not working. I need to...

I have a range of cells and want to subtract a value from each cell. Can I do that without having to do each one individually? Here is a very shortened...

I have a formula using a 3D range, =max(Oct:Sep!AB124). Is there anyway I can return the address of the max value, which could be on any one of 12...

I have this formula in a cell: {=SUM(IF(ISTEXT(C6:Q6),1,0))} When I press F2 and hit enter excel removes the brakets from the formula and instead of having...

I have a col. A and Col. B Column A Column B 10 44363 10 56634 20 26348 20 32688

I have a column of dates that are expiry dates of professional trainings. I want the cells in the same column to display "Good" if the expiry is more than...

I have about 100 tabs each signifying a customer profile what I need now is to automatically take the worksheet name (customer number) and give a cell that...

Hi. I've got a large workbook that has 13 seperate pages. Each of the first 12 pages has locked, hidden and cells that can be edited. The 13th sheet is...

Trying to count # of times these two conditions are met using formula below as an array. Answer always...

I need your help... What is the correct formula if I need to convert the date to a text value in a month format? I have two columns the DATE column and then...

Hello All Please excuse me for an unclear subject. I will try to decribe my problem as clear as possible. I have a spreadsheet which helps me measure...

The formula below works but I would like to omit lines that are blank. i.e....

I'm trying to find a formula that will add 2 for each multiple of 5 for a given cell. Let's say the value of cell A1 is 15. I'm looking for a formula that...

I am trying to have the "ROUNDOWN" function as my true, and "ROUNDUP"as my false... See my current incorrect formula below.... ...

I need to add these into "conditional formating" section... in "conditon 2" But dont know how to enter the formula. I keep getting error messages that the...

I need to be able to, in one quick move, go from the last entry in a spreadsheet column to the top of the next column and be able to do this repeatedly.

I have found that using the header I can insert pictures that will not obstruct the test of the spreadsheet, however while it looks like I can do the same...