elpresidente
New Member
- Joined
- Oct 24, 2002
- Messages
- 2
I'm racking my brain trying to figure out a formula that will perform the following: I have expense/income codes set up for my business such as fuel is code 10, labor is code 20, deposits are code 50 and so on. Let's say cell A2 has a 10(for fuel code) in it and B2 has a dollar amount that reflects A2. I need a formula that will find all 10's and sum the corresponding cells that reflect the dollar amounts. I'm sure it's a simple formula but I need some help. I'm comfortable with Excel but a formula rookie. Thanks in advance and if I get rich I'll send you a consulting fee!