SUMPRODUCT syntax problem

[2Dumb4This]

I'm trying to pull the sum of a certain array that are equal to another array. I've historically used OpenOffice, which I like, but I need my documents to be more portable. So now I've converted to Excel. My document had certain formulas that Excel didn't like. The first of which I'm struggling to convert.

In OpenOffice the following formula did the job =SUMPRODUCT(H3:H18=$E3:$E18), if 6 items matched in these array, then the cell would simply return a value of 6, this returns the dreaded #VALUE error in excel.

Any help would be appreciated.

[Tony Valko]

In Excel it would be:

=SUMPRODUCT(--(H3:H18=$E3:$E18))

On a side note...

Please change the thread title to something more specific. They don't like ambiguous thread titles here.

[2Dumb4This]

Changed. Thank you very much. I'll give this a try and let you know the results.

[Tony Valko]

"Formula Problem" is still too ambiguous.

How about this: SUMPRODUCT syntax problem

[2Dumb4This]

I knew it would be easy. Worked great. Thanks again for your help.

[Tony Valko]

You're welcome. Thanks for the feedback!

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.