Formula to include a specific range and all new entries

J Tech

Hi,

I have a formula as per below and I want it to start calculating from row 6 to the bottom and include all new entries.

Can you please help me?

=SUMIF([1 - BT]6:[1 - BT]44, "KS", [1 - # of BT]6:[1 - # of BT]44)

J. Craig Williams

The easiest way is to count the entire column and subtract the rows you are not interested in (rows 1-5)

=SUMIF([1 - BT]:[1 - BT], "KS", [1 - # of BT]:[1 - # of BT]) - SUMIF([1 - BT]1:[1 - BT]5, "KS", [1 - # of BT]1:[1 - # of BT]5)

There are other ways, but this is by far the easiest.

I hope this helps.

Craig