This works for Number Values but not Text Values

[nuhnell]

Hello, this is my first post asking for help with a formula/function so I apologize if not all the info is here. I am also still learning VBA. I'll watch the thread to answer any questions if clarification is needed.

I am using this formula/function in one of my macros

Sheets("Ordering_Tool").Select
Range("I2").Select
ActiveCell.FormulaR1C1 = _
"=SUMPRODUCT((RC[-6]=AndresenNeeds!R2C6:R3999C6)*AndresenNeeds!R2C11:R3999C11)"
Range("I2").Select
Selection.Copy
Range("I3:I3999").Select
ActiveSheet.Paste

This works perfectly to get numerical information for specific items onto another sheet where I need it to go. When I tried to use this with SKUs that have letters in it i get a #VALUE error and it does not work.

Could anyone help me figure out a function to use to make this work.

[way2020]

Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you
have removed any private information, remember this is a public forum and so available to anyone.
We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

This will help tp understand the issue. SUMPRODUCT treats non numeric as Zeros.