Search results

I have a set of deadline data ordered thus; A:A has the project number B:B has a description of the event C:C has the target finish date D:D has the actual finish E:E and F:F have the department which has to complete the milestone with E:E and F:F having different headers and different...

Hi All, I think I'm making a pigs ear of the excel sheet I'm trying to pull together. I need a formula that sums the area CTS!H3:DO200 if CTS!H2:DO2 = Invoicing Total!C4. I tried to pull together a SUMIF formula but failed miserbly :( In addition I need a formula that lists the description...

Hi All, I have the following formula which doesn't work; =SUMIFS(Data!$G$2:$G$3000,Data!$A$2:$A$3000,CTS!$A40,Data!$F$2:$F$3000,"=>"&CTS!I$2,Data!$F$2:$F$3000,"<"&CTS!J$2) Data!G2:G3000 is a list of prices Data!A2:A3000 is a list of project numbers Data!F2:F3000 is a list of...

Hi All, I have a two tables like the ones below; Pricing Tool A------ B------ C------ D------ E------ F------ G------ H------ -------Initial- 1------ 3------ 6------ 12----- 24----- 36----- Test 1- 1 Test 2- 2----- TOTAL-- 380...

Hi All, I have absolutely no idea if this is possible but if it is then my life would be so easy. I plot out the revenues of several departments and have to follow the forecast of the lead department. This means that I spend hours pouring over someone elses spreadsheets to ensure I have all...

Hi All, I have been banging my head against a brick wall all day on this one, any help would be greatfully appreciated I have been trying to create a database sheet that looks up values on >200 sheets and formats them into a flat dataset so I can use them for lookups in the database...

Hi, I am trying to find a way to obtain the text from a comment in a cell. I need this to work similar to a lookup since the cell address will be dependant on the project number (to give the row) and the column header (to give the column). I found a UDF on Ozgrid...