Tip: Using Excel's SUMPRODUCT Function

Posted by accountingweb on Aug 9 2001 353 printer friendly

Excel provides a useful function called SUMPRODUCT which can be used to find summation of multi dimension data series.

For example:

You have number of cartons in cells A1:A5
Number of units in each carton in cells B1:B5
Price of each unit in cells C1:C5

You want to find the total cost of the stock. The answer is simple. You use the following formula:

=SUMPRODUCT(A1:A5,B1:B5,C1:C5)

You don't need to multiply A1*B1*C1 and then copy it down.

This function seems to be quite handy and can be used for many other calculations.

This handy tip appeared recently on our sister site, AccountingWEB.co.uk.

Voice of the Editor

Even though any accounting auditor would tell you it seems like there are an awful lot of tax accountants out there, surely one-third of the country isn't made up of tax preparers, so it's rather startling news to learn that one-third of Americans like to do their taxes. Who knew?

This Week on AccountingWEB

Bill Walter of Gross, Mendelsohn & Associates and Harold Gaar of TravisWolff LLP weigh in on mobile technology use while employees are at work.

WestArk RSVP and Fayette County Community Action Agency – organizations that received grant funding through the IRS Tax Counseling for the Elderly (TCE) program – spoke with AccountingWEB about how they assist senior citizens in their communities.

CPA Robert Raiola, who heads the Sports & Entertainment Group of Fazio, Mannuzza, Roche, Tankel, LaPilusa, LLC, talks NFL player income taxes with AccountingWEB.

Retiring KPMG Centennial Professor of Accounting at the University of Texas at Austin McCombs School of Business Robert May, PhD talks with AccountingWEB about his rewarding forty-three-year career.