Function Help
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"))
-
" =SUMIFS( " works the same way as " =SUM(COLLECT( "
Just another option to keep in mind.
You can use SUM with COLLECT like this:
=SUM(COLLECT([% of Cost]9:[% of Cost]34, [Assigned To]9:[Assigned To]34, ="Cement Guy"))
" =SUMIFS( " works the same way as " =SUM(COLLECT( "
Just another option to keep in mind.