Excel Accounting Formula Needed

Microsoft Excel 2010
June 30, 2010 at 13:55:01
Specs: Windows 7, IBM
I'm trying to figure out a formula for the purpose of accounting. I have a column for project name, a column for account number, and a colum for expense. The project name and account number fields are drop down menus for employees to select for their expense reports. At the bottom, I want a summary of each project with expenses for each account shown. So basically, sum if a=b and if c=d kind of thing. What do I need to type to get it to work? Right now, I'm only showing 0's. Thanks!

See More: Excel Accounting Formula Needed

Report •

June 30, 2010 at 13:59:27
When posting in a help forum, it's best to use a subject line that is relevant to the contents of the post.

If everyone posted with a subject line of "Excel Formula" or "Microsoft Excel" (something we see a lot!) we wouldn't be able to tell one question from another.

I've fixed the subject for this thread.

Excel Forum Moderator

Report •

June 30, 2010 at 14:04:31
Have you looked at the SUMPRODUCT function? With the limited information you have provided, it sounds like that might work for you.

The Excel Help files on SUMPRODUCT are pretty limited, so look here instead:


If you think that SUMPRODUCT will work, but have trouble constructing the formula, come on back with some specific details as to what is in each column and what you are trying to do, and we'll see if we can be of any more help.

Report •

Related Solutions

Ask Question