Formula

[nitum]

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

[NBVC]

Try:

=SUMIF(Tasks!I2:I7,1,Tasks!F2:F7)

and

=SUMIF(Tasks!I2:I7,1,Tasks!G2:G7)

your formulas are array formulas that would need to be confirmed with CTRL+SHIFT+ENTER to work.

I also assume the range in the first formula should be I2:I7...