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!
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Forum statistics

Threads
1,213,513
Messages
6,114,072
Members
448,546
Latest member
KH Consulting

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