Hello,
I would like to be able to sum numbers in column I based on conditions in
A,B,C but I would like to make the condition in each column optional, so I
could use the conditions in A and B only for instance (or in any combination)
The formula below works without the optio
=SUMPRODUCT(($A$112:$A$1155=$A$14)*($C$112:$C$1155 =$C$14)*($B$112:$B$1155=$B$14)*(I$112:I$1155))
How can I add something like if($A$13=true,($A$112:$A$1155=$A$14), etc
in the SUMPRODUCT formula?
Any help is appreciated.thanks

--
caroline