“If you can’t describe what you are doing as a process,
you don’t know what you’re doing”
W. Edwards Deming

Data pickup functions: SUMIF

In previous guides we have considered the use of VLOOKUP and INDEX / MATCH as a means of matching constants with a corresponding date on a horizontal timeline.

In this modelling guide, we will look at SUMIF.

Help make the handbook better