HI ALL
I am trying to sum few columns based on a single criteria using sumproduct formula.
Formula:
Please Login or Register to view this content.
The above formula gives me error. However when I change "CC250" to "CA250" I am getting correct answer.
I even tried putting two minus signs but no avail.
Formula:Please Login or Register to view this content.
Any guess why I am getting error.
Please post a sample file
It suggests data problems in CB:CC: what error do you get?
What error are you getting?Originally Posted by Ravana
If there are any TEXT entries in the sum range you'll get the #VALUE! error.
Try this array formula**:
=SUM(IF(D10:D250=D37,BZ10:CC250))
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks