i am having problem in sumproduct due to #N/A error in my data. file is attached
i need help plz do the needful
Regards
Sajid
i am having problem in sumproduct due to #N/A error in my data. file is attached
i need help plz do the needful
Regards
Sajid
Last edited by sajidbagi; 11-28-2011 at 04:06 PM. Reason: problem solved
Perhaps try using COUNTIFS, i.e.
=COUNTIFS(A2:A10,D3,B2:B10,">=0")
Audere est facere
no i have to sum the values with given criterias
1 get rid of na
like this
=IF(ISNA(VLOOKUP(A2,$D$3:$E$5,2,FALSE)),0,VLOOKUP(A2,$D$3:$E$5,2,FALSE))
2 the sum product can then be
=SUMPRODUCT(--(A2:A10=D3),--(B2:B10>=0))
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Or, after taken care of the NA one way or another ( I'm not a big fan of the IF(ISNA...) technique) you can use a Pivot Table to summarize
Use SUMIF if you want to SUM values:
=SUMIF(A2:A10, D3, B2:B10)
Using your posted workbook...
try this:
Is that something you can work with?Please Login or Register to view this content.
Or using an array formula:
confirm with Ctrl-Shift-Enter.Please Login or Register to view this content.
Cheers,
Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.
oh and change your profileMS Office Version:Excel 2003
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks