Recent content by will31

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 xld, I found =SUM(INDEX(CTS!$H$3:$DO$200,,MATCH(C4,CTS!$H$2:$DO$2,0))) works a treat. Thanks for taking the time to reply. Will

Hi xld, This gives a #Value error. The CTS!H2:DO2 part gives a error, just to be sure I selected it manually and it still didn't work. Can SUMIF do this?

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...

Thanks Kevin, worked perfectly!

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 Hui, I have 10 tests, I thought of using lookups but the formula would be pretty big. Is there another way?

Hi Luke, The table contains a price per sample value, this decreases as the sample number increases due to economies of scale. The price for each row therefore is the total of the cost per sample by the number samples for each of the tests. e.g. Test 1 1 sample = 1 x 100 Test 2 2...

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...

Posted it here so you can see it; http://www.mrexcel.com/forum/showthread.php?p=2510737#post2510737 A picture speaks a thousand words...

OK Excel Jeanie didn't work, Anyone recommend an uploading site?

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...

I created a formula; =GetCommentText((INDIRECT("'"&$B3&"'!$O$"&MATCH(MultiSearch!$C3,INDIRECT("'"&$B3&"'!$A$2:$A$1000"),0)))) this returns the correct coordinates and sheet but doesn't give the comment. I'm confused why it doesn't work

Thanks Hui that works great. Do you know of a way to use formula's to obtain the cell reference based on a condition? The column will not change but the row will be dependant on the contents of column A:A.