AuditBible
January 19, 2018, 03:17:59 PM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
Sirius Satellite Radio Inc.
 
   Home   News Alerts Help Search Calendar Members Contributions Staff List Login Register  

Microsoft Store
Del.icio.us Digg FURL FaceBook Stumble Upon Reddit SlashDot Google Bookmarks

Pages: 1   Go Down
  Add bookmark  |  Print  
Author Topic: Create lists; Use SUMIF to summarize data  (Read 1984 times)
 
0 Members and 1 Guest are viewing this topic.
beancounter
Administrator
*****
Offline Offline

Gender: Male
Experience: 1985
Posts: 168



Activity
100%


View Profile WWW
« on: July 15, 2008, 02:58:42 AM »

...ever have an insured provide you with an Excel summary where the data isn't quite summarized in a usable manner?  Wouldn't it be nice if there was some way you could easily summarize the data without having to do lots of manual work?  Well, there is!

Example 1 - Provides you with what I'll call a List Formula that will help you create a short, but exhaustive list of class codes (or department numbers, etc.) from a long list where those codes are unordered and repeated several times.  Then, a SUMIF Formula that will summarize the data by those codes.

Example 2 - Provides you with two versions of SUMIF Forumlas: one summarizes the data based on a cell reference (just like the SUMIF Formula in example 1), and the other sumarizes the data using fixed terms you supply.

Just copy and paste them right into your audit worksheet, or download these two sheets to your hard drive for future use.

There are 2 attachment(s) in this post which you cannot view or download. Please login to have access to attachments.
Example 1.xls
Example 2.xls
« Last Edit: August 01, 2008, 09:39:23 AM by beancounter » Logged

bc
Pages: 1   Go Up
  Add bookmark  |  Print  
 
Jump to:  

Related Topics
Subject Started by Replies Views Last post
How to create a Screenshot Tech Talk beancounter 0 2016 Last post July 31, 2008, 10:26:54 AM
by beancounter
Microsoft Store
Unique Hits: 1849239
Powered by MySQL Powered by PHP Powered by SMF 1.1.21 | SMF © 2015, Simple Machines
AuditBible © 2008 | Sitemap
Valid XHTML 1.0! Valid CSS!