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?