I posted this up on VBA Express but have not had any reply from them. I
was wondering if I could get some help here.

Please see attached file. I'm trying to use arrays to sum a group of
numbers based on 2 variables which is selected on a separate cell.

I realised that it only works with 1 variable. I'm trying to make it
work with about 5 variable. Please see attached file. You can see that
it says #N/A if I tried to do this with 2 variables.

=SUM(IF(($G$3:$G$15=TRANSPOSE((IF($B$3:$B$7="Yes", $A$3:$A$7))))*($H$3:$H$15=TRANSPOSE((IF($E$3:$E$5= "Yes",$D$3:$D$5)))),($I$3:$I$15)))

This formula doesn't work!!

Any solution is really appreciated. Please note that you're not suppose
to create any additional columns or cells. All formula must be in 1 cell
and must also work if each variable has 50 selections.

Thank you.


+-------------------------------------------------------------------+
|Filename: arra.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3628 |
+-------------------------------------------------------------------+

--
wezred
------------------------------------------------------------------------
wezred's Profile: http://www.excelforum.com/member.php...o&userid=25591
View this thread: http://www.excelforum.com/showthread...hreadid=390110