Vanilla Forums has been nominated for a second time in the CMS Critic "Critic's Choice" awards, and we need your vote! Read more here, and then do the thing (please).
Our new Indie Games subforum is now open for business in G&T. Go and check it out, you might land a code for a free game. If you're developing an indie game and want to post about it, follow these directions. If you don't, he'll break your legs! Hahaha! Seriously though.
Our rules have been updated and given their own forum. Go and look at them! They are nice, and there may be new ones that you didn't know about! Hooray for rules! Hooray for The System! Hooray for Conforming!
I've seen a lot of really smart Excel people on here, so I hope someone can help.
I have Excel 2003 at work. We're slowly upgrading to 2007, but I still need a solution that will work on 2003.
I have a long list of data consisting of 4 columns. Acct number. Sub Acct number. Description. Amount. Each Acct number repeats anywhere from 0 to 100 times. Sub Acct numbers also exists multiple times. So do Descriptions. However each combination of Acct number and Sub Acct number is unique.
I want an equation in one cell to find an amount for a specific combination of Acct and Sub Acct number without creating any new columns.
1. I want to be able to find any amount given an Acct and a Sub Acct.
2. Is there some way to find the sum of the amounts for multiple Accts?
I don't want to solve this using databases since there will be thousands of specific accounts
I can't use any functions like "SumIfs", because that was added in Excel 2007. Sumif is still good though.