file:Dropdown lists

**alancauchi** · 11-30-2009, 10:36 AM

Originally Posted by NBVC

I think it would be easier to follow if you could post a sample workbook

check this sample file, please

**NBVC** · 11-30-2009, 10:46 AM

You should first ensure that the numbers entered in column H of each sheet is formatted as numbers and not text

Then you can use formula:

=SUMIF(INDIRECT("'Mr X Issue "&B$1&"'!$D$6:$D$18"),$A2,INDIRECT("'Mr X Issue "&B$1&"'!$H$6:H$18")) in B2 and copied down and across the table.

Sample shows som REF errors, because those referenced sheets not in your sample

**alancauchi** · 11-30-2009, 11:18 AM

Originally Posted by NBVC

You should first ensure that the numbers entered in column H of each sheet is formatted as numbers and not text

Then you can use formula:

=SUMIF(INDIRECT("'Mr X Issue "&B$1&"'!$D$6:$D$18"),$A2,INDIRECT("'Mr X Issue "&B$1&"'!$H$6:H$18")) in B2 and copied down and across the table.

Sample shows som REF errors, because those referenced sheets not in your sample

Ur a marvellous genius........... It worked 100%

The formula reads the dates from the tab name is it? Can it read from the date in the sheet?