+ Reply to Thread
Results 1 to 9 of 9

sum multiple if's and able to easily expand

  1. #1
    Registered User
    Join Date
    04-21-2015
    Location
    CA,USA
    MS-Off Ver
    7
    Posts
    13

    sum multiple if's and able to easily expand

    I have multiple tasks that are checked off when complete. I want to automatically sum the value of each task at the end of the row in which it sits
    Is there an easier way to make it simple to rite and easy to expand tasks?

    See attached
    Attached Files Attached Files

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,731

    Re: sum multiple if's and able to easily expand

    so how do you define a task checked OFF
    can not see them in the sheet
    do you mean a dates ? in columns J,L,M,N,P

    if so
    =COUNT(J3,L3,M3,N3,P3, "<>")
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    04-21-2015
    Location
    CA,USA
    MS-Off Ver
    7
    Posts
    13

    Re: sum multiple if's and able to easily expand

    Yes, where ever there is a date that task has been completed. I tried to make it simple so they can put anything in there and as long as it is not blank it recognizes the task completion. I didn't understand your solution, it is not an expression I am familiar with.

  4. #4
    Registered User
    Join Date
    04-21-2015
    Location
    CA,USA
    MS-Off Ver
    7
    Posts
    13

    Re: sum multiple if's and able to easily expand

    I see how your thinking but that doesn't really work. It gives me the number of cells that have tasks completed but each completed task is worth a different value
    i.e. H3 =2% (H2) * (78.6 (Q3) - 8 (O3)) =1.4
    H6 =2% (H2) * (36.9 (Q6) - 0 (O6)) =0.7

  5. #5
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,731

    Re: sum multiple if's and able to easily expand

    Sorry I dont understand the formulas and why you are not removing the glass install

    When there is a date in the cells
    J3,L3,M3,N3,P3
    what are you adding up for each of those columns

  6. #6
    Registered User
    Join Date
    04-21-2015
    Location
    CA,USA
    MS-Off Ver
    7
    Posts
    13

    Re: sum multiple if's and able to easily expand

    Anything written in cells J3:J8 and L3:N* and P3:P8 indicates that the work is complete. The calculation for that is done in column R. Here is the formuls for R3 which evaluates which tasks on row 3 are complete.

    =IF(J3="",0,H3+I3)+IF(L3="",0,K3*$K$2)+IF(M3="",0,K3*$K$2)+IF(N3="",0,K3*$N$2)+IF(P3="",0,O3)

    H3 is a calculation of Q3, O3 and H2.

    =(Q3-O3)*$H$2

    Where Q3 is the total labor for that line, O3 is a specific amount of labor and H2 is a percent of the labor remaining after subtracting O3 from Q3

  7. #7
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,731

    Re: sum multiple if's and able to easily expand

    so you have the formula OK then

  8. #8
    Registered User
    Join Date
    04-21-2015
    Location
    CA,USA
    MS-Off Ver
    7
    Posts
    13

    Re: sum multiple if's and able to easily expand

    What I'm looking to do is write it in cleaner way so that I can expand it easily.. Right now it would take a long time to add 3 more tasks. and this seems a little convoluted. Basically multiple nested if statements. My Question is, 'Is there an easier way?"

  9. #9
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,731

    Re: sum multiple if's and able to easily expand

    i dont see anything that maybe quicker /easier - but other members may

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Easily resize multiple columns
    By newdoverman in forum Tips and Tutorials
    Replies: 1
    Last Post: 01-07-2014, 08:22 AM
  2. Replies: 1
    Last Post: 02-25-2013, 10:38 PM
  3. Replies: 3
    Last Post: 11-10-2012, 06:46 PM
  4. How to make multiple references from one worksheet to another easily
    By banessa in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-10-2012, 01:47 PM
  5. [SOLVED] Merge multiple spreadsheets easily
    By joebird in forum Excel General
    Replies: 10
    Last Post: 05-10-2012, 02:24 PM
  6. Replies: 1
    Last Post: 04-22-2012, 06:49 PM
  7. Easily adding multiple addresses into invoices
    By pinkpearl8130 in forum Excel General
    Replies: 2
    Last Post: 01-03-2009, 06:04 PM
  8. Replies: 2
    Last Post: 03-09-2006, 04:35 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1