Hi I have the following calculation in my column E: =((D3-C3)*24)-(NETWORKDAYS(C3,D3)*24)+24 Column D is Date/Time order completed in format: dd/mm/yyyy...

Need help to calculate the total number of hours excluding the 48 hrs of a weekend. Currently my spreadsheet looks like this: C3 (date/time) start D3...

Hi Currently I have the following string setup: =SUMPRODUCT(--('Awaiting Further Info'!B2:B294="NU"),--('Awaiting Further Info'!F2:F294="D"),'Awaiting...

I need help with the following: I need to search column A for all instances of "N1", in column F is the value for that row..... ....what can I use to get...

I need help with the following: Column 'I' contains Annual Rental Column 'M' contains Date Ceased My end of financial year is 31 March 2007 I need to...

Hi Currently I am using Sumproduct to count column B "NU" and column F "D" but now I also need it to look at column I (which contains the value for that row)...

Hi When protecting a selection of cells in a workbook (Format cells -locked) then password protect worksheet, the cells that are not locked allow text...

I have an IF formula and need to change the font colour of the FALSE value to red - how do I do it?????? Help!!!!

I need to attribute 10 points for every £1000 revenue achieved. So for example £1800 would be 10 points, 5760 would be 50 points etc. If I have column A with...

I would like to create a function that changes every month. For example in month 1 the formula would be SUM(A1:A1), in month 2 it would be SUM(A1:A2), in...

An incentive scheme at work allocates points to employees and the three highest earners per week receive bonus points. Therefore, I want excel to locate the...

Is it possible, when using the MATCH function, to find all matches rather than only the first match when using '0'? --- Message posted from...

Is it possible using the PERCENTILE function to select the middle 90% of an array for analysis therefore discarding the top 5% and bottom 5%. I have a...

Hi there, I would like to develop variations of the SUMIF function. For example, in Column A are the names of consultants (Bob, Jim, Bill etc)and in Column B...

Dave, thanks! But, please see my more complex edit... Regards Andy --

I am simply trying to link cells in different worksheets using SUM. However, if a cell is empty, SUM returns a 0 but I want it to return as empty. The formula...

Is is possible to sort a table according to the date of say A or B (rather than A then B) so that a table is essentially sorted by the the earliest date in 2...

I have a spreadsheet that is linked to another spreadsheet using...

Hope you can help!! Column A=dates eg 17/06/05 etc Column B=Product eg A, B, C, D, E etc Column C=Quantity eg 1, 2, 3, 4, 5 etc Using SUMPRODUCT I am trying...

Using the below formula, #VALUE! is returned: =SUMPRODUCT(--(MONTH(Log!$A$2:$A$200)=MONTH(Stats!$D1)),--(Log!$D$2:$D$200=(Stats!$A3))) I think it is because...