7

Hi Folks,

I have the following formula used to track specific assets:

=SUMIF({EventDate_req}, $DateNeeded$1, {Asset2_Range})

This adds up the count in  each row in the Asset2_Range that matches the date needed.

 

We created individual one column ranges for each asset (Asset1, Asset2, Asset3) etc.

3

I am trying to find the min value of CHILDREN in a column of numbers where the value of the [% Complete] cell in the row of that column is not = 100%, but, again, only for the CHILDREN. 

Using

=MIN(COLLECT(CHILDREN(), [% Complete]:[% Complete], @cell < 1))

or

=MIN(COLLECT(CHILDREN([Days Till

3

Hi, 

I am trying to get the sumif function to work for me and I am having trouble. I am trying to count the dollar amount of invoices in column Invoice Amount if the the JOB# column has "BO" in it. 

These are the formulas I have tried so far:

=SUMIF([JOB#]:[JOB#], IF(FIND("BO", [JOB#]:[JOB#]),