C
Carrach
My formulae below is not working, can you help?
Column H contains 'NZ' or 'SZ',
column I is in 20/5/2010 format,
column G contains 'trade' or 'fdi',
Column E is a list in rows 4 to 16 incl containing text statements.
=SUMPRODUCT(--('outputs detail'!$H$4:$H$999="NZ"),--(MONTH('outputs
detail'!$I$4:$I$999)=5),--('outputs detail'!$G$4:$G$999="trade"),--('outputs
detail'!$B$4:$B$999='outputs detail'!$E$4))
Column H contains 'NZ' or 'SZ',
column I is in 20/5/2010 format,
column G contains 'trade' or 'fdi',
Column E is a list in rows 4 to 16 incl containing text statements.
=SUMPRODUCT(--('outputs detail'!$H$4:$H$999="NZ"),--(MONTH('outputs
detail'!$I$4:$I$999)=5),--('outputs detail'!$G$4:$G$999="trade"),--('outputs
detail'!$B$4:$B$999='outputs detail'!$E$4))