I am currently using Excel 2010. I need to create a formula that will provide me with a a total of the numbers in the cells in one range that meet the criteria of specific text in a different range. Range X contains the specific text and Range Y contains the numbers that need to be added together if they match the text in Range X.
I tried using SUMPRODUCT as follows but was not successful:
=SUMPRODUCT((RANGE X,"TEXT")*(RANGE Y,"=>1"))
=SUMPRODUCT((RANGE X,"TEXT")*(RANGE Y, =>1))

I'd appreciate any suggestions.

Thanks,
MLCall