Hi

I have a sheet which has three columns - well, several, but these are
the ones which are important here :) -

D =3D "Responding to:" this will be 'Advertisement', 'Leaflet' or
'Campaign'

F =3D "=A3Weekly rate"

and

G =3D "=A3Arrears"

On sheet 2 I want to be able to sum the arrears by 'responded-to'-type,
ie, sum items in sheet 1, column G if they responded because of the
Leaflet.

I'll also then do a similar thing for an average weekly rate by
'responded-to'-type.

Trouble is, I can't see how to get SUMIF to work here.

Does anyone have any suggestions?

Thanks in advance

Steve