Long formula results shows up twice

[concepo]

Hi

I have a problem with a long formula, where the resultes shows up 2 times.

The forumula must take total tons produced, and / with total time to get the average kg. produced pr. hour (but only if it all from the same batch.

I have uploaded the file here (and hopes it the make better sense

http://expirebox.com/download/87857f...5af472735.html

Thanks, and have a nice weekend,

[JohnTopley]

in D8 and copy down

=IF(COUNTIF($A$8:A8,A8)=1,SUMIF($A$8:$A$2982,$A8,$U$8:$U$3982)/(SUMIF($A$8:$A$3982,$A8,$H$8:$H$3982)*1)/24,"")

[concepo]

Thanks alot

Works perfect

[JohnTopley]

Thank you for the feedback. Could you please mark thread as solved ("thread Tools" at top of first post).