Formula

nitum

New member
Joined
Jan 27, 2014
Messages
10
Reaction score
0
Points
0
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
 

Attachments

  • Test_Execution_Status_C.xls
    47.5 KB · Views: 51

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
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...
 
Top