1. 

   PJS
   

   Member
   Joined: Nov '10
   Posts: 3

   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)

   Posted 2 years ago #
2. 

   kchiba
   

   Member
   Joined: May '10
   Posts: 260

   Hi PJS,
   Try this

   =SUMPRODUCT(--(Sheet2!$N:$N=B3)*--(Sheet2!$B:$B=A4)*Sheet2!$D:$D)

   Posted 2 years ago #
3. 

   PJS
   

   Member
   Joined: Nov '10
   Posts: 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?

   Posted 2 years ago #
4. 

   kchiba
   

   Member
   Joined: May '10
   Posts: 260

   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

   Posted 2 years ago #
5. 

   PJS
   

   Member
   Joined: Nov '10
   Posts: 3

   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.

   Posted 2 years ago #

RSS feed for this topic

Reply

You must log in to post.

Welcome to Chandoo.org. New here?

Thank you so much for visiting us & taking first step to become awesome in Excel. Please use below links to navigate our site.

Learn Excel - Topics » Excel for Beginners - Tutorials » Excel Formula Examples » Array Formulas » Excel Charts » Pivot Tables » Project Management using Excel » Excel Dashboards » Excel VBA » Advanced Excel

Our Products Full Training Programs » Excel School » Excel Dashboard Classes » Excel VBA Classes » Excel Financial Modeling » Excel for PMs Crash Courses » Excel Formula Course » Excel Dashboards Course Downloads » Excel PM Templates » Excel Formula E-book

About us » About Chandoo.org » Welcome » Best of Chandoo.org » FREE Excel Downloads » Contact Details » Excel Forums