Add the Group By clause as explained in the error message, I am assuming that your statement is correct.
SELECT SUM(R.r_LimeGypsum),C.a_pH,C.c_FirstName,R.r_LimeGypsum
FROM dbo.Cultivator_tbl C
LEFT JOIN dbo.Recommendation_tbl R
ON C.Cid=R.Did
GROUP BY C.a_pH,C.c_FirstName,R.r_LimeGypsum
[Edit]Follow solution 1 above, there was no solution when adding my solution, he beat me to it, and gave you useful links.[/Edit]