• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

SUMIF formula conversion for Excel 2003

P

PJS

New Member
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)
 
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?
 
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
 
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.
 
You must log in or register to reply here.
Back
Top