Function Help

Erik Johnson, PE

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?

Brian W

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

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

 

Just another option to keep in mind.