Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Thursday, 09 November 2017
  1 Replies
  6.3K Visits
0
Votes
Undo
I'm creating a ledger of sorts. In column C I have created a dropdown list of descriptions - Call it Dog, Cat, Bird, Mouse, etc. In the next column is a dollar amount. Similar to a checkbook ledger.

I would like to create a formula that would look for a single description from column C with the running dollar amount from the next column. For example


A B C D E
1 dog $2
2 cat $4
3 dog $3
4 Bird $1
5 Bird $1

THIS SHOULD BE MY END RESULT
Dog $5
Cat $4
Bird $2

I don't care how many animals. I care $$ for each category

Thank you
Create a Pivot table with B in the row and Dollar in summation. This will give you what you need
  • Page :
  • 1
There are no replies made for this post yet.