Sum formula (Long)

Hi

I need a formula , with different criterias.
But can't get I working

I have uploaded the excelfile her:
https://www.dropbox.com/s/hl7az1g7v2...mula.xlsx?dl=0

(The build-in file upload is not working here ;()

Would be very very thankful for the help .

Have a nice sunday,

Kind regards,

Concepo (Denmark)

Hi

Thanks for the reply..

The upload-fuction dosn't work here... When a push the attacment-button, and blank box shows up.
Not possible to browse / upload.

Have tried on 3 different machines (Windows Server, Windows 10, Mac (iOS)... Different locations
Dirrerent browser (Explorer, Chrome, Firefix)... The machines on diffent locations, and clean machines without popup-stopper. and other programs.

Have also tryied to create another user (Same problem) , and also tryied Compatibily View Settings ajustments.

(And I am in Denmark)

So I choose to share it on my Dropbox

In W3

=(SUMIFS($U$3:$U$19,$A$3:$A$19,$A3,$I$3:$I$19,V3)/(SUMIFS($H$3:$H$19,$A$3:$A$19,$A3,$I$3:$I$19,V3)*1))/24

See attached

Thanks … Works fine

But in the empty cells it return an #DIV/0! Error

I have tryied to add a IFERROR to the formula, but now it return another error in the empty cells.

How to I change the formula, so it return a blank cell “ if there is no result ?

Thanks

Arrrhhhhhg ;(((
Can't get it working.

Using danish version of Excel But it comes with errors when I translate the formel ;(

Can you add the IFERROR formula to the file, og upload it ? (Then Excel will translate automatic when I open the file)

and again thanks for using your time on this.

Thanks

THANKS

You saved my day

Have a nice weekend

@Tony,
Thanks from me too!! I had copied the formula to the appropriate cells, rather than drag down. Silly me!!!