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)
SUMIF formula conversion for Excel 2003(5 posts) (2 voices)
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?
If you are looking for the number of cells used, you can use COUNTIF
Or if it is more complex, please give details
I spent so long trying to find the SUMIFS solution my brain couldn't contemplate an easy solution as you have suggested.
You must log in to post.