R
RJMAT
Hello,
Please review the formula I have created below. Is there a way to have
mulitple criteria's? Is this example, I used =211. I like to use multiple
#'s. I don't think that nesting is the answser. Please advise.
Rich
=SUMPRODUCT(--('K:\0506FISC\SSOP''s June 06\[3308 - Trial Balance.xls]3308 -
Trial Balance 11-1-2006'!$C$2:$C$1500=A23),--('K:\0506FISC\SSOP''s June
06\[3308 - Trial Balance.xls]3308 - Trial Balance
11-1-2006'!$B$2:$B$1500=211),--('K:\0506FISC\SSOP''s June 06\[3308 - Trial
Balance.xls]3308 - Trial Balance 11-1-2006'!$D$2:$D$1500))
Please review the formula I have created below. Is there a way to have
mulitple criteria's? Is this example, I used =211. I like to use multiple
#'s. I don't think that nesting is the answser. Please advise.
Rich
=SUMPRODUCT(--('K:\0506FISC\SSOP''s June 06\[3308 - Trial Balance.xls]3308 -
Trial Balance 11-1-2006'!$C$2:$C$1500=A23),--('K:\0506FISC\SSOP''s June
06\[3308 - Trial Balance.xls]3308 - Trial Balance
11-1-2006'!$B$2:$B$1500=211),--('K:\0506FISC\SSOP''s June 06\[3308 - Trial
Balance.xls]3308 - Trial Balance 11-1-2006'!$D$2:$D$1500))