Good Afternoon

I need some help on the following SUMPRODUCT:

=(SUMPRODUCT((Centre=C$4)*(TEXT(Date,"mmmm yyyy")="JANUARY 2011")*(Group=$A5)*(Value>0)*(Value)))

It returns the value of #VALUE!

As part of trying to solve the problem I have tried:

=(SUMPRODUCT((Centre=C$4)*(TEXT(Date,"mmmm yyyy")="JANUARY 2011")*(Group=$A5)*(Value>0)))

Which returns the result of 2 - there are 2 rows which are complient with the above SUMPRODUCT. What I was hoping was that the final (Value) would return the SUM of those two rows: 3.

What am I doing wrong?

Many thanks
Who is Participating?
Rory ArchibaldConnect With a Mentor Commented:
=SUMPRODUCT((Centre=C$4)*(TEXT(Date,"mmmm yyyy")="JANUARY 2011")*(Group=$A5)*(Value>0),Value)

WashcareAuthor Commented:
Many thanks
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.