SUMIFS returning #N/A

[chive90]

I'm trying to sum Column D on Sheet2 but only where Column E and Column F meet certain requirements.

Column E contains an IF ISNA VLOOKUP, where, if found, the output is Yes, otherwise it is left blank.
Column F contains free text of 'IN' or 'OUT'.

My formula is currently: =SUMIFS('Sheet2'!D:D,'Sheet2'!E:E,"Yes",'Sheet2'!F:F,"IN")

However, in cell C10 on Sheet1 where I am entering the formula, it is returning #N/A

Does this have anything to do with the fact that I am using a IF ISNA VLOOKUP formula to count the number of 'Yes' entries, and SUMIFS won't count text that is part of a formula output? If so, how can I get around this as the VLOOKUP is critical to use as more entries are added.

Thanks

 

[Georgiboy]

Are you able to share the data with XL2BB?

Do you have any errors in columns D, E or F?

 

[Fluff]

Check that you don't have #N/A errors in column D

 

[chive90]

Check that you don't have #N/A errors in column D

Are you able to share the data with XL2BB?

Do you have any errors in columns D, E or F?

You both got it. Sorry amateur mistake on my part. D had a handful of N/A's so I've added in an additional criteria of "<>#N/A" and now working ok.
Cheers for the quick replies.

 

[Fluff]

Glad we could help & thanks for the feedback.