Is there any way to put into this formula to extend the higher range out further.
=SUMIFS(Summary!$C$4036:$C4145,Summary!$B$4036:$B4145,"Hudson C")
Here is my issue if I need to insert more rows on sheet "Summary" and add more info. The C4145 and B4145 wont go higher. I am trying not to go all...