# What is wrong with this formula??

• 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

• Hi,

At first glance, you should review the basic building structure SUMIFS

SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)

In addition whole columns is often counter-productive use defined ranges...

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner

• =IFERROR(SUMIFS('Errors-YTD'!\$H:\$H,'Errors-YTD'!\$H:\$H,">0",'Errors-YTD'!\$L:\$L,"<="&D\$14,'Errors-YTD'!\$C:\$C,"Customer",'Errors-YTD'!\$E:\$E,\$B33),0)

Rory
Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

• Well Done !!!

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner

Rory
Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

I am so jealous

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner

• So am I, especially as I should have seen it right before my eyes, a bit of "wood and trees" popping in I think..

Kind regards

DezB

• Thanks to Rory ... and thanks for your feedback

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!