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

  • Thread starter Thread starter Jonas Magcase
  • Start date Start date
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
 
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 :-)
-------------------------------------------------------------------------- --
 
Back
Top