Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

sumif

ResolvedVersion Standard

Anthony has attended:
Excel Intermediate course
Excel Advanced course

Sumif

How do you do it?

RE: sumif

Hi Anthony

Thank you for the question

As you may recall as of yesterday at the end of the day we covered how to write the sumif formula

here it is again just in case

=sumif(region,"east",sales_99)

to break it down for you goes as follows

you will sum the sales for the east region for the year 1999

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

Excel tip:

How to Spell Check an Excel 2010 Worksheet

Excel 2010 does not automatically spell check a document. So, here's how to manually spell check a worksheet.

Either select the ''Review'' tab in the Ribbon, go to the ''Proofing'' section and click ''Spelling.'' Or, simply press F7.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.