Hi Folks.
I know this is going to be a silly error on my my part, but can anyone tell me why excel is not seeing this as a formula??
=IFERROR(SUMIFS('Errors-YTD'!$H:$H,>0,'Errors-YTD'!$L:$L,"<="&D$14,'Errors-YTD'!$C:$C="Customer",'Errors-YTD'!$E:$E,$B33),0)
H:H is a column of numbers and I need it to sum up all the numbers that are above 0
L:L is a column of dates and the formula looks for any dates less that or equal to the date in D14
E:E is a list of codes and the formula looks for the code that is in B33
Somehow I'm missing a quotation or a comma I think..
Any help, much appreciated as usual please...
Kind regards
DezB