Results 1 to 3 of 3

=SUMPRODUCT(SUMIFS....Formula Ammendment

Threaded View

3smees23 =SUMPRODUCT(SUMIFS....Formula... 05-22-2012, 04:33 AM
NBVC Re:... 05-22-2012, 08:17 AM
3smees23 Re:... 05-22-2012, 08:53 AM
  1. #1
    Forum Contributor
    Join Date
    12-30-2008
    Location
    Woking, England
    MS-Off Ver
    Excel 2007
    Posts
    197

    =SUMPRODUCT(SUMIFS....Formula Ammendment

    Hi,

    I have the following formula in S5 on the takeoff tab:

    =SUMPRODUCT(SUMIFS(Data!G:G,Data!A:A,$G$4:$O$4,Data!G:G,"<0"),$G5:$O5)
    It is adding up the any power amounts in column G (Data) that are under zero.

    I have added a column I in Data. There are 2 devices in there that has a value of +2000. I need this somehow incorporated 'adding that value if it's selected' into the above formula. So if these are picked in the same manor as all the other equipment then it adds it to the total of S5.

    For example, in the attached I have added a piece of equipment in J5 (takeoff) that has a value of 2000 in column I (Data). At present the total in S5 reads -5100. I need to adapt the formula so it makes it -3100.

    Any Help will be appreciated.

    Cheers

    Sam
    Attached Files Attached Files
    Last edited by 3smees23; 05-22-2012 at 08:54 AM.

Thread Information

Users Browsing this Thread

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

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