I have several worksheets - i need to reference from one sheet 3 different
values
IE text, text, then add the values.
EG range A1:A1000 looks for a value =HPI835
Range B2:B2000 looks for a value on sheet to which must be =A2
then it must add all the values found together an put it onto sheet 3 in BD34
if this does not make sence then have a look at this formula i used which
works well for a few cells but not for a range of cell it as an array
formula
{=SUM(IF((Report!$B$2:$B$20000="ESM005")*(Report!$ F$2:$F$20000='Kit
Planes'!$A4),Report!$C$2:$C$20000))}
please can somebody help me to solve my problem..
many thanks