Hey all, column A I have my weeks 1-53 for the year and I want to be able to change each week and for it to sum column B numbers for each week. I can't get this to work for me, I have done it before but can't remember how I had it set up.
Can someone please help me out?
Not much to go on but it sounds as though you need SUMIF or SUMIFS (or SUMPRODUCT, but that would probably be overkill. SUMIF most likely will do.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks