sumproduct error

I am using Sumproduct formula but getting error '#Value!


It works fine with just


but with the added Range !!!!

the range is the amount column so I am expecting the result to be the sum of all items with FI where the age band is 0-2 and YesNo is = Yes.

Appreciate someones help on this please.
Who is Participating?
NBVCConnect With a Mentor Commented:
Is Range the same size as the other ranges?

Try also, instead:

Saqib Husain, SyedEngineerCommented:
Check the data in Range for any error values
Saqib Husain, SyedEngineerCommented:
or maybe there is text within that range which gives error with --
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.