Hi ,
can some one please help me?
For H18 in sheet1 tab i want the following formula to be displayed
=SUM((Tasks!I2:G7=1) * (Tasks!F2:F7))
AND for H19 in sheet1 tab i want the following formula to be displayed
=SUM((Tasks!I2:I7=1) * (Tasks!G2:G7))
Please note that column I has conditional formating see attachment
Thanks in advance
can some one please help me?
For H18 in sheet1 tab i want the following formula to be displayed
=SUM((Tasks!I2:G7=1) * (Tasks!F2:F7))
AND for H19 in sheet1 tab i want the following formula to be displayed
=SUM((Tasks!I2:I7=1) * (Tasks!G2:G7))
Please note that column I has conditional formating see attachment
Thanks in advance