Formula to find and add totals

fsjenkins2000

New Member
Joined
Feb 24, 2005
Messages
7
i need help finding the right formula to find a specific text in colum A (Groceries) and then coresponding that to different value in the same row in a different column (D)>

A B C D E
catagory place depost withdarw total
Groceries wal-mart -150.00 1500.00
enter movies -18.00 1482.00
Groceries albertsons -100.00 1382.00

So i need a formula to find "Groceries" and corespond withdrawl amount in same row colum D. and place it off to the side or different workbook.

thanks for any help at all[/url]
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

tactps

Well-known Member
Joined
Jan 20, 2004
Messages
3,459
How about something like this:
=if(a2="Groceries",d2,0)

or to add the column:
=SUMIF(A:A,"Groceries",D:D)
 

fsjenkins2000

New Member
Joined
Feb 24, 2005
Messages
7
thanks alot that was it... sometimes it can be soo frustrating figuring these things out.

cheers
 

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
Try this: handles Deposits and Withdrawals
Book1
ABCDEFGHI
1CategoryPlaceDepositWithdrawTotal
2Starting Balance1650DepositWithdraw
3GroceriesWal-Mart1501500Groceries0250
4Banking5802080Banking5800
5EntertainmentMovies182062Car0250
6CarService2501812
7GroceriesAlbertsons1001712
Sheet2


E3 is =$E$2+SUM($C$3:C3)-SUM($D$3:D3), filled down
H3 is =SUMIF($A:$A,$G3,C:C), filled down and across

Denis
 

Watch MrExcel Video

Forum statistics

Threads
1,122,554
Messages
5,596,811
Members
414,104
Latest member
imamalidadashzada

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top