How to stop sum if function

[Schalk]

Please have a look at my attachment.

In the "INVENTORY" tab, E4-6 and F4-6 are working fine. G4-6 I need to stop counting on the "STOCK MOVEMENT'" tab after the entry 'STOCKTAKE' entry in A9. As I will be using this every month, the entry will not always be in E9 as the date will differ each month. Is there any way I can adjust the formula so I can, for example type a date or value into G3 on the "INVENTORY" tab to indicate where I want the formulas in G4-6 to stop counting?Book1.xlsx

[daffodil11]

Maybe something like this:

Please Login or Register  to view this content.

I'd highly recommend changing your other SUMIF in E and F from:

=SUMIF('STOCK MOVEMENT'!B:B,B4,'STOCK MOVEMENT'!C:C)

to

=SUMIF('STOCK MOVEMENT'!B4:B45313,B4,'STOCK MOVEMENT'!C4:C45313)

Otherwise, your formulas are calculating against over 1,000,000 rows. 45,000 is a lot less, and when you have lots of SUMIF formulas you will see a significant change in performance.

[Schalk]

Yup Im already noticing a slower performance. Where do I put the code you gave and what will it do?

[Schalk]

The formula is only picking up some of the values but not all

[daffodil11]

I thought you said you didn't want it to pick up all. Only as far down as STOCKTAKE.