SUMIF Formula needs to be copy to column and row

adaliu7

New Member
Joined
Jul 6, 2012
Messages
1
I need to compile data from the same workbook but different sheet with SUMIF formula

The three three SUMIF formulas are all correct, however I don't know how to implant the same data for different column and row:

formula 1:
=SUMIF(January!C4:C10,B11,January!D4:D10)+SUMIF(January!G4:G10,B11,January!H4:H10)+SUMIF(January!K4: K10,B11,January!L4:L10)

Change/copy to next column, criteria NO change but range and sum-range for Month change to February, March, .... November and December.

Change/copy to next row, criteria Change to B12, B13....B19, B20. Range and sum_range do NOT change.



Formula 2:
=SUMIF(January!C14:C16,B23,January!D14:D16)+SUMIF(January!G14:G16,B23,January!H14:H16)+SUMIF(January !K14:K16,B23,January!L14:L16)


Formula 3:
=SUMIF(January!C20:C29,B30,January!D20:D29)+SUMIF(January!G20:G29,B30,January!H20:H29)+SUMIF(January !K20:K29,B30,January!L20:L29)


Formula 2&3 are basically the same just compelling different data. Again, the same how to:
Change/copy to next column, criteria NO change but range and sum-range for Month change to February, March, .... November and December.

Change/copy to next row, criteria Change to B24, B25....B27, B28. Range and sum_range do NOT change.


See attached file, all pink cells are the one needs to be filled with formula. Many thanks!
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

cyrilbrd

Well-known Member
Joined
Feb 2, 2012
Messages
4,071
Office Version
  1. 365
Platform
  1. Windows
  2. Mobile
Hi, where is the file?
 

Watch MrExcel Video

Forum statistics

Threads
1,122,518
Messages
5,596,622
Members
414,082
Latest member
sasmita

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
Top