Function Help

How would I go about trying to create a formula that scan down a column finding and grouping the same "assigned to" and then grabing that specific %cost and totaling them up in another cell?

CpWz_002.png

Comments

  • You can use SUM with COLLECT like this:

    =SUM(COLLECT([% of Cost]9:[% of Cost]34, [Assigned To]9:[Assigned To]34, ="Cement Guy"))

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    " =SUMIFS( " works the same way as " =SUM(COLLECT( "

     

    Just another option to keep in mind.

    thinkspi.com