Well the first formula you quoted is different to what you have now, so perhaps you want: =SUMIF('Jira Reference'!
$K:$K;"="&C5;'Jira Reference'!$L:$L)/ 3600+SUMIF('Jira Reference'!$E:$E;"open";'Jira Reference'!$L:$L)/ 2/3600 although maybe C5 contained the word closed. Pete On Oct 3, 4:24*pm, Brile wrote: Hi, actually it does not add the numbers...Do you have another...