Sumif ?????

[MGumbrell]

I have attached a zip file to help explain.

I have a Range A2:A20 that the user enters amounts
I have a Range B2:B20 that the user enters a Code against the amount
I have a Range A27:A32 that Identifies the codes

In Range B27:B32 I would like to automatcally total all the same associated codes.

I hope that I have explained myself clearly enough and look forward to someone coming back with a very easy and obvious (but not to me) response.

Regards, Matt

 

[qafself]

Hi Matt

Like this

=SUMIF(B2:B20,"A",A2:A20)

Repeat for the other criteria

HTH

Ed

 

[MGumbrell]

Ed

Many thanks, I have some comfort that I was at least on the right track.

Regards, Matt

 

[qafself]

Glad to have helped - thanks for the feedback

Ed