Hi,
I'm currently using the following formula to sum one criteria/condition.
I was wondering how do I add 4 more criteria/conditions to the existing formula?
=SUMIFS(Sheet3!$E:$E,Sheet3!$A:$A,"11",Sheet3!$I:$I,C$3)
I want to add where Sheet3!$A:$A,"1" +Sheet3!$A:$A,"2" +Sheet3!$A:$A,"3" +Sheet3!$A:$A,"4"
could this be possible?
thanks,
Winston
I'm currently using the following formula to sum one criteria/condition.
I was wondering how do I add 4 more criteria/conditions to the existing formula?
=SUMIFS(Sheet3!$E:$E,Sheet3!$A:$A,"11",Sheet3!$I:$I,C$3)
I want to add where Sheet3!$A:$A,"1" +Sheet3!$A:$A,"2" +Sheet3!$A:$A,"3" +Sheet3!$A:$A,"4"
could this be possible?
thanks,
Winston