Results 1 to 2 of 2

Thread: If formulas

  1. #1
    Neophyte strawberrydelight's Avatar
    Join Date
    Jul 2019
    Excel Version

    If formulas

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I want to find the sum of several columns based on the criteria in two other columns. I have this formula that returns the sum of two columns, based on two criteria but want to include two more columns in the sum.

    =SUM(IF('Entry Sheet'!$E$18:$E$517='Entry Sheet'!W52,IF('Entry Sheet'!$F$18:$F$517=$N$9,IF('Entry Sheet'!$M$18:$M$517>0,'Entry Sheet'!$M$18:$M$517),0),0),0

    Basically, it is saying If column E on an entry sheet = a certain code in column F (F holds a formula pointing to W code held on another page) and if the value of column N and Column M is >0, then put the sum of columns N and M together the second page in column D. This long formula sits in column D on the second page.

    I want to include two more columns K and L into the sum. I've tried all kinds of things and not getting anywhere.

    Click image for larger version. 

Name:	Screen Shot 2019-07-09 at 22.25.16.jpg 
Views:	145 
Size:	107.4 KB 
ID:	9236Click image for larger version. 

Name:	Screen Shot 2019-07-09 at 22.25.36.jpg 
Views:	140 
Size:	92.8 KB 
ID:	9237

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Ipswich, Suffolk, England
    Excel Version
    Office 365 Subscription
    This question has been posted in at least one other forum.

    Do not post any further responses in this thread until a link has been provided to these cross posts.

    Whilst we would rather you didn't cross-post, we know that there may be a valid reason for doing so. All we ask is that you provide the links in your original post to your question in the other forum(s). Read this to understand why.

    This forum is full of volunteers that give up their own time to help others, something that should be respected and not taken for granted. It’s never nice for someone to find out that a problem they have spent time solving for you has already been answered somewhere else without them knowing, and so we ask you to make it clear that you have also asked elsewhere.
    Please provide the link(s). If you are unable to do so, tell us where else you have posted this query.
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts