I need to know if I can get a formula for the following: If cell E14 is "y" and G14 is less than or equal to 14 the H14 should be "y"

How can I make the following cell reference drag and fill up to B66 ='F20 survey'!$B7 ='F20 survey'!$B8 ='F20 survey'!$B9 .... ='F20 survey'!$B66 When I...

If I have a formula that includes a named range, how can I refer to a specific cell in that range? For example =filename!rangename ... and I want the value...

Ar Bs Ec Ar Bs Ec 20 36 14 10 7 I am trying to sum the above columns. Column 1-3 supercede columns 4-6, in the sense that if column 4 has a figure in there...

Well, I'll start it to what I have so far, but I need one last improvement to the formula to make it true, and I keep getting...

I have a client using Excel 95 and when he open my workbook - Excel 2007 he gets the error message #NAME, can anyone help with this problem. Campatibility...

Hi, I am trying to sum the number of divisions based on work area category. If work area category (K6:K169) is 1, then count division number (column...

Ar Bs Ec Ar Bs Ec B A C B B I am trying to count entries for the data above. The 1st 3 columns are equal to 1 entry each, and the last 3 columns are equal...

if cell e 14 = y and cell g14 is less than 15, h14 should be y...how do i do it? Thanks

My spreadsheet has two colums side by side. Column A: contains letters such as GM, GMA, GMQ etc. Column B: contains complete, partial,...

I have created a drop down box and within the drop down box there are product names. for example I will use Apple, Orange and a Pear. When I select Apple in...

When converting a decimal to a fraction, I get some responses like 1/67 when what I am looking for is increments of 1/64. Then I want to display 10/64 as...

Is it possible to link two cells (that has the same information) and when you update one it automatically updates the other?

I'm using VLOOKUP to import data from a pivot table. Currently I have set it up so that VLOOKUP uses the row names and the count with an IF forumla to import...

Hello All I have several sheets with a high column and row count, and takes about 3 minutes to calculate. Each sheet has a column of unique numbers for...

I have a list of data - which has the potential to be up to 10,000 rows in length. The structure of the date is as follows (Although fairly simplified): Each...

Is it possible to link two cells and when you update one it automatically updates the other?

Hello, In the formula =sum(B6:B50) is there any to make the value represented here by the “6� a variable? Is there any I could point it to, say, the...

Hey, I found a stupidity bug (yes it was stupid to have missed it). When you detail a hyperlink, all is fine. When you format the hyperlink, all is fine. ...

I have a pivot table that sums the activity of different items throughout different months. Many times an amount will come in as a positive amount and then...