Results 1 to 5 of 5

Conditional product of sum

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-10-2008
    Location
    Austin
    Posts
    660

    Conditional product of sum

    Maybe I should say conditional product of conditional sum.
    Eitherway, the values in column J are summed if P is column R for the repective row.

    =SUM(IF($R$5:$R$246="P",(J$5:J$246),IF($R$5:$R$246=" ",(J$5:J$246))))
    Now, I'm confused on how to change my formula to multiply the result above
    by the value in column Q for the same respective row.


    anyhelp in setting up the formula is appreciated.

    TIA,

    bdb
    Last edited by bdb1974; 03-03-2009 at 07:08 PM.

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