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
Bookmarks