I have a table containing numerical values in column D and text in
column E.

The text in column E can be either S, M or P

In cell D31 I want to total the values in column D corresponding to the
letter S in column E
In cell D32 I want to total the values in column D corresponding to the
letter M in column E
In cell D33 I want to total the values in column D corresponding to the
letter P in column E

I've tried using COUNTIF and the Conditional Sum Wizard, but I can't get
something that does the job.

Could someone please suggest a formula to do the job?

Many thanks

Regards

Peter