SUMIF variables
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 |
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 "Steve" wrote in message oups.com... 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 |
That's great.
Thanks, Julie Steve |
All times are GMT +1. The time now is 04:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com