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
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...
Bookmarks