SUMIF variables

[Steve]

Hi

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

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

F = "£Weekly rate"

and

G = "£Arrears"

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

 

[JulieD]

Hi Steve

=SUMIF(Sheet1!$D$1:$D$100,"Leaflet",Sheet1!$G$1:$G$100)
should work

if you still can't get it to work, could you copy & paste the exact formula
you're using.

Cheers
JulieD

Hi

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

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

F = "£Weekly rate"

and

G = "£Arrears"

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

 

[Steve]

That's great.

Thanks, Julie

Steve