Try:

=IF(C13="developer", SUMPRODUCT(E$10:H$10, E13:H13), IF(C13="business
analyst", SUMPRODUCT(E$9:H$9, E13:H13), IF(C13="application
manager", SUMPRODUCT(E$9:H$9, E13:H13))))

In article .com,
wrote:

I need help guys....i used this formula

IF(C13="developer",SUMPRODUCT(E$10:H$10,E13:H13),I F(C13="business
analyst",SUMPRODUCT(E$9:H$9,E13:H13)), IF(C13="application
manager",SUMPRODUCT(E$9:H$9,E13:H13)))

And got this error

You've entered too many arguments for this function

any suggestions?