Adding Numbers on 1 Column based on the Value of another Column

J

Jonas Magcase

Hey Everyone,

I am creating a budget sheet for myself. One of the columns is "credit" or
"debit" and another column is the amount. What I am looking to do is tally
up all the credits and all the debits in 2 separate cells. What is the best
way to go about this?

Best wishes,

Jonas
 
J

Jonas Magcase

Thanks Ken!

Ken Wright said:
=SUMIF(range,criteria,sum_range)

=SUMIF(A1:A100,"Credit",B1:B100)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

-------------------------------------------------------------------------- --
It's easier to beg forgiveness than ask permission :)
-------------------------------------------------------------------------- --
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding Numbers on 1 Column based on the Value of another Column 1
Moving date from 1 column to another based on a value and changing the sing. 1
Calculating two fields on based of the value of one field 3
Two Calculations in one column 4
Any way to convert column of numbers from positive to negative? 3
Separate value in 1 column to 2 columns based on value in other co 10
Simple Question on Addition 3
Copy of value from one sheet to another with matching column values 1

Top