P PJS New Member Nov 11, 2010 #1 Could i please get some help with using the following formula in excel2003 =SUMIFS(Sheet2!$D:$D,Sheet2!$N:$N,B3,Sheet2!$B:$B,A4)
Could i please get some help with using the following formula in excel2003 =SUMIFS(Sheet2!$D:$D,Sheet2!$N:$N,B3,Sheet2!$B:$B,A4)
K kchiba Active Member Nov 11, 2010 #2 Hi PJS, Try this =SUMPRODUCT(--(Sheet2!$N:$N=B3)*--(Sheet2!$B:$B=A4)*Sheet2!$D:$D)
P PJS New Member Nov 11, 2010 #3 Thanks kchiba. It does work, i was just looking up the SUMPRODUCT topic and was nearly at that answer. Appreciate your help. Is there any way to also give the number of cells used in $N:$N, like the COUNTIFS function?
Thanks kchiba. It does work, i was just looking up the SUMPRODUCT topic and was nearly at that answer. Appreciate your help. Is there any way to also give the number of cells used in $N:$N, like the COUNTIFS function?
K kchiba Active Member Nov 11, 2010 #4 Hi PJS, If you are looking for the number of cells used, you can use COUNTIF Or if it is more complex, please give details cheers kanti
Hi PJS, If you are looking for the number of cells used, you can use COUNTIF Or if it is more complex, please give details cheers kanti
P PJS New Member Nov 11, 2010 #5 Thanks kanti I spent so long trying to find the SUMIFS solution my brain couldn't contemplate an easy solution as you have suggested. Thanks again.
Thanks kanti I spent so long trying to find the SUMIFS solution my brain couldn't contemplate an easy solution as you have suggested. Thanks again.
