Ok.. so you want to use an Excel formula and you know it is, say, SUMIF that you want to use, but what data does it need and where?

Before you go searching through help or cranking up your browser, let Excel do the work for you. Just type =SUMIF in a cell and press Control + Shift + A and Excel will give you the list of data required. It’s dead simple and it saves heaps of time.


Helen Bradley