[Solved] Autofill formulas, exclude the auto fill for certain cells

hajjash

New member
hello,

I have this formula:

=SUMIFS('Calendar Tracker'!O2:O1517, 'Calendar Tracker'!B2:B1517, "="&B36,'Calendar Tracker'!H2:H1517,"<>")

I wan to autofill it vertically, so that only &B36 increases, not the remaining cells, so the next cell would be:

=SUMIFS('Calendar Tracker'!O2:O1517, 'Calendar Tracker'!B2:B1517, "="&B37,'Calendar Tracker'!H2:H1517,"<>")
=SUMIFS('Calendar Tracker'!O2:O1517, 'Calendar Tracker'!B2:B1517, "="&B38,'Calendar Tracker'!H2:H1517,"<>")
=SUMIFS('Calendar Tracker'!O2:O1517, 'Calendar Tracker'!B2:B1517, "="&B39,'Calendar Tracker'!H2:H1517,"<>")
=SUMIFS('Calendar Tracker'!O2:O1517, 'Calendar Tracker'!B2:B1517, "="&B40,'Calendar Tracker'!H2:H1517,"<>")

and so on. How can I do this?

Thanks!
 
hello,

I have this formula:

=SUMIFS('Calendar Tracker'!O2:O1517, 'Calendar Tracker'!B2:B1517, "="&B36,'Calendar Tracker'!H2:H1517,"<>")

I wan to autofill it vertically, so that only &B36 increases, not the remaining cells, so the next cell would be:

=SUMIFS('Calendar Tracker'!O2:O1517, 'Calendar Tracker'!B2:B1517, "="&B37,'Calendar Tracker'!H2:H1517,"<>")
=SUMIFS('Calendar Tracker'!O2:O1517, 'Calendar Tracker'!B2:B1517, "="&B38,'Calendar Tracker'!H2:H1517,"<>")
=SUMIFS('Calendar Tracker'!O2:O1517, 'Calendar Tracker'!B2:B1517, "="&B39,'Calendar Tracker'!H2:H1517,"<>")
=SUMIFS('Calendar Tracker'!O2:O1517, 'Calendar Tracker'!B2:B1517, "="&B40,'Calendar Tracker'!H2:H1517,"<>")

and so on. How can I do this?

Thanks!
Hello Hajjash,

I hope you are doing well. You can use the absolute reference if you don't want the autofill or auto increase of rows and columns.
Here is the updated formula.

=SUMIFS('Calendar Tracker'!$O$2:$O$1517, 'Calendar Tracker'!$B$2:$B$1517, "="&$B36,'Calendar Tracker'!$H$2:$H$1517,"<>")
 
Hello Hajjash,

I hope you are doing well. You can use the absolute reference if you don't want the autofill or auto increase of rows and columns.
Here is the updated formula.

=SUMIFS('Calendar Tracker'!$O$2:$O$1517, 'Calendar Tracker'!$B$2:$B$1517, "="&$B36,'Calendar Tracker'!$H$2:$H$1517,"<>")
Thank you very much!
 

Online statistics

Members online
1
Guests online
14
Total visitors
15

Forum statistics

Threads
311
Messages
1,378
Members
568
Latest member
WilliamHon
Top