error sumif

[muss1210]

Hello forum

I have the below code which works great until i get a error

Please Login or Register  to view this content.

This works for the error is i am summing on teh same sheet but i cant get the above code to run when it's on anothwer sheet

Please Login or Register  to view this content.

thanks in advance for the help

[etaf]

where is the error

could you upload a sample spreadsheet with the error

I cannot reproduce

=SUMIF(sheet1!L:L,A4,sheet2!I:I)

if the result pulls back an error - then you could use
IFERROR (SUMIF(sheet1!L:L,A4,sheet2!I:I) , "")

But I dont think thats what you mean

#N/A are ignored
DIV/0 is ignored

[muss1210]

Hello etaf

I cant upload the sheet as it's massive.

Basically column A is by month and column B is adding up everything in that month.

Sheet 1 contains the data as a list, in column L is the date and in Column I is the value, not all lines have a value in column I which is producing a error so when trying to SUMIF it wont add up as there is a error in the list.

[JohnTopley]

Upload a small extract.

[muss1210]

Here you go , i have done a smaple for you to look at

[finalazy]

try this
=SUMIFS(Sheet1!I:I,Sheet1!L:L,A4,Sheet1!I:I,"<>"&"#N/A")

[muss1210]

And the winner is Finalazy

thanks alot for that works perfectly, i did find some extemely long ways to do the same thing but yours is short and to the point.

[finalazy]

You are welcome. You should have attached the file in the beginning, I'm 100% certain etaf or john will be able to provide the answer as well. Anyway glad it helps =)
Cheers!