Sumif Multiple Columns With Varying Offset

Altec23

New Member
Joined
Apr 11, 2013
Messages
1
I'm trying to figure out how to sum multiple columns from a database given a certain criteria. So, basically I have a database with contract numbers going down column A. In column B through M are the expenses for that particular contract over 12 months. I would like to be able to input the contract number and then the number of months to add together. So for example, if I said 3 months, it would add the first three columns (Jan-Mar). If I said 6 months, it would add the first six columns (Jan-Jun). The database has thousands of contracts that grow with time so it would be ideal to be able to use a format selecting the whole column (i.e. A:A). Any help would be greatly appreciated! By the way, I am using Excel 2007. Thanks!
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Forum statistics

Threads
1,196,385
Messages
6,014,980
Members
441,860
Latest member
Store154

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top