Sumifs with ranges

The table below adds up all the sales between the account numbers by month. The example shown below uses MYOB data.

Data table for sumifs

In the case above the table is on a sheet called ‘Calculations’ and the financial data is on ‘Sheet1’ The criteria is in cell Calculations!F4 and in this case is 4-100

sumifs1

Therefore to add in greater to or equal than “>=” & is added before the cell reference so the full reference becomes: “>=” & Calculations!F4
A second criteria adds the upper range for sales, in this case 4-9999 located in cell F5 and a third criteria adds the date range. So this formula adds any account code greater than or equal to 4-1000 and less than or equal to 4-999 for the month of July 2011.

Combine this with the great example of Excel Hyperlinks from the ever awesome Chandoo.org for a very impressive dashboard.

Chandoo interactive graph

training

tv

On line via the Alchemex website

On site in NSW Sydney Region, the training is taylored to your needs, be it Alchemex or Excel.

 

report writing

Business Reports directly in Excel at the touch of a button using Alchemex.

All the major accounting packages are supported: MYOB, ABM, Sybiz, Sage packages (Handisoft, Accpac etc)

Excel & Alchemex Tips

Alchemex Tips & Tricks
There's often a little gem in the Alchemex Tips & tricks.

Excel Tips & Useful sites
Chandoo and Ozgrid are very useful......

© Orginal Template by Flipside Digital