I want to count the number of cells that contain numbers greater than 1930 and less that 1940. The following does not seem to...

Hi There, Is it possible to combine IF OR AND functions? I can combine IF with AND and IF with OR but not all three. E.g. Is it possible to put the...

Hi there, I have written the following formula, which works...

Is it possible to write the IF FUNCTION with more than 1 arguement e.g. If A1=zzz and A2=yyy then enter True/False in B2 Or: If A1=zzz and A2=yyy and A3=xxx...

Does the SUMPRODUCT function find dates? An example of my formula,as follows, will not work i.e.returns...

Is it possible to do cross tabulations in Excel? If so, how?? Kind regards --- Message posted from http://www.ExcelForum.com/

Hi there, In column A I have start dates, in column B completion dates, and in column C the DAYS360 function in order to calculate time taken. However, the...

Does anyone know if VLOOKUP will recognise a ~ symbol? My datasource contains them, and I am not having any luck getting the function...

Hello, Firstly, I am a basic Excel user, alas coding etc means nothing to me. Please help, I have a drop down list where I woudl like it possible to select...

HI, I can make a drop down list, however I need to be able to select more than one option. Nay help would be great

How can I Always ROUND UP, a number to a multipal of 5 in excel

In need to us something similar to IF function but to have multiple answers ie if A3=5 then A5=$9 If A3=6 then A5=$12 IF A3=55 Then A5=$30 Any help would be...

I am trying to use the following function to get an average using letters as variables under a criteria. However, there are blank cells which are being...

using vlookup i can select a value from a different worksheet, but can i select a range of values to sum together?

I want to compare two different optimal scenarios answers obtained from Solver but they are quite close. I want to say, well scenario X's optimal value is so...

I have 30 entries in a list which are the heights of students in my class in cm. I want to plot a bar chart of this data so the spreadsheet is arranged to show...

I have a spreadsheet with roughly 2000 rows and 18 columns. As part of a macro, I sub total columns 7 and 17. I use a macro to copy select cells into a...

Hello, Can someone help alter this formula? At the moment the core part of it counts the cells which do not contain the value NA The trouble is the COUNTIF...

Hi, Im trying to check that one row of data satifies a criteria, then if it does it counts an entry in another column adjescent to it. Example: - Column A...

Hi there, I have a big file and in a few sheets I use freeze panes which works fine. But each time I open the file anew after having saved my changes, the...