Simple Excel Functions by Bryan Crosland

Author:Bryan Crosland [Crosland, Bryan]
Language: eng
Format: azw3
Published: 2017-10-05T04:00:00+00:00

Note: With Excel 2007 the programmers decided to change the order of things if you are used to the original SumIf you will notice that the sum_range now comes before the criteria_range.

Things to try:

1) Open the file logic_and_mathematical.xlsx

2) Select the tab SUM, SUMIFS

3) In cell G10 enter =SUMIFS(D6:D53,B6:B53,"Engineering")

The total expenses for Engineering will now be displayed. This is a SUMIFS based on one criteria.

Further things to try:

1) Open the file logic_and_mathematical.xlsx

2) Select the tab SUM, SUMIFS

3) In cell G14 enter =SUMIFS(D6:D53,B6:B53,"Finance",C6:C53,"May")

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.