Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Some sort of conditional sum?
I have a table of data set up as follows:
Customer 31/10/08 30/11/08 31/12/08 abc 20 35 50 def 45 30 24 In a separate sheet I have a summary sheet whichwill show totals as follows: 31/10/2008 Total Port 65 I want the Total port to change according to the date in the cell above i.e. the total will change to 65 if I put 30/11/08 and 74 if I put 31/12/08. I don't think this is complicated but at this time of the day its doing my head in so any help would be appreciated. Many thanks, Andrew |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Some sort of conditional sum?
Try this:
A10 = date to match =SUM(INDEX(Sheet2!B2:D3,,MATCH(A10,Sheet2!B1:D1,0) )) -- Biff Microsoft Excel MVP "Andrew Mackenzie" wrote in message ... I have a table of data set up as follows: Customer 31/10/08 30/11/08 31/12/08 abc 20 35 50 def 45 30 24 In a separate sheet I have a summary sheet whichwill show totals as follows: 31/10/2008 Total Port 65 I want the Total port to change according to the date in the cell above i.e. the total will change to 65 if I put 30/11/08 and 74 if I put 31/12/08. I don't think this is complicated but at this time of the day its doing my head in so any help would be appreciated. Many thanks, Andrew |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Some sort of conditional sum?
Thanks Biff, Worked a treat!!
Andrew "T. Valko" wrote in message ... Try this: A10 = date to match =SUM(INDEX(Sheet2!B2:D3,,MATCH(A10,Sheet2!B1:D1,0) )) -- Biff Microsoft Excel MVP "Andrew Mackenzie" wrote in message ... I have a table of data set up as follows: Customer 31/10/08 30/11/08 31/12/08 abc 20 35 50 def 45 30 24 In a separate sheet I have a summary sheet whichwill show totals as follows: 31/10/2008 Total Port 65 I want the Total port to change according to the date in the cell above i.e. the total will change to 65 if I put 30/11/08 and 74 if I put 31/12/08. I don't think this is complicated but at this time of the day its doing my head in so any help would be appreciated. Many thanks, Andrew |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Some sort of conditional sum?
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Andrew Mackenzie" wrote in message ... Thanks Biff, Worked a treat!! Andrew "T. Valko" wrote in message ... Try this: A10 = date to match =SUM(INDEX(Sheet2!B2:D3,,MATCH(A10,Sheet2!B1:D1,0) )) -- Biff Microsoft Excel MVP "Andrew Mackenzie" wrote in message ... I have a table of data set up as follows: Customer 31/10/08 30/11/08 31/12/08 abc 20 35 50 def 45 30 24 In a separate sheet I have a summary sheet whichwill show totals as follows: 31/10/2008 Total Port 65 I want the Total port to change according to the date in the cell above i.e. the total will change to 65 if I put 30/11/08 and 74 if I put 31/12/08. I don't think this is complicated but at this time of the day its doing my head in so any help would be appreciated. Many thanks, Andrew |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort of like SUMIF and COUNTIF - but return a conditional value | Excel Discussion (Misc queries) | |||
sort function for dates does not sort properly in Office 2007 Exc. | Excel Worksheet Functions | |||
Conditional Sort? | Excel Discussion (Misc queries) | |||
sort a cell that was highlighted by conditional formating? | Excel Worksheet Functions | |||
Sort by conditional formats? | Excel Worksheet Functions |