Forum home » Delegate support and help forum » Microsoft Excel Training and help » Sumif

Sumif

ResolvedVersion 2003

Mon 30 Mar 2009, 11:41 Delegate Charles said...

Charles has attended:
Excel Advanced course

Sumif

How to sum up the numbers with the "sumif" function with different criteria at the same time?

Thanks.

Charlie

Fri 3 Apr 2009, 13:29 Trainer Amanda said...

RE: sumif

Hello Charlie

Thank you for your question.

I think you would perhaps need to look at using DSUM rather than SUMIF to achieve this, providing your data is organised in columns with headings (i.e. like a database/list).

Kind regards
Amanda

Fri 3 Apr 2009, 13:31 Delegate Charles said...

RE: sumif

That is very helpful. Thanks a lot.

Charlie

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

View all Excel hints and tips

Sumif

Sumif

RE: sumif

RE: sumif

Excel articles

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010