Sumifs with criteria

Hello all
On the attached worksheet i wish to count the data in col x using the criteria in cols A to E,then divide by the value in col AJ.Can the formula i am using be modified to return a blank cell in the result col AT,when the value in AJ is blank.(its now returning #DIV).Can the result also be given to 1 dec place.What im trying to achieve is shown in col AW

Formula is SUMIFS(X:X,A:A,A2,D:D,D2,E:E,E2)/AJ2

Many thanks for help given

Hi,

In AT2:

=IFERROR(ROUND(SUMIFS(X:X,A:A,A2,D:D,D2,E:E,E2)/AJ2,1),"")

Regards

hi there. another variation:
=IF(AJ2<>"",ROUND(SUMIFS(X:X,A:A,A2,D:D,D2,E:E,E2)/AJ2,1),"")