B

#### Brile

If I already have a "SUMIF" formula (see below) which returns a certain

value and I would like Excel to add to that formula an additional function

that adds certain data from an additional column in a tab - where and how do

I do that in the formula? The thing I would like to do is: Add data from a

column but only all the rows with a special value in that column, for example

with the string "Open".

=SUMIF('Jira Reference'!$J:$J;"<="&C5;'Jira Reference'!$L:$L)/3600

I also to that formula would like to add the value of those same rows that

says "Open" but from another additional column and also multiplicate that

with 50%.