Search for a Keyword. Add Value from another cell.

[Solved/Closed]
Report
Posts
2
Registration date
Tuesday January 3, 2017
Status
Member
Last seen
January 3, 2017
-
Posts
2
Registration date
Tuesday January 3, 2017
Status
Member
Last seen
January 3, 2017
-
I'm looking for something that's very difficult to search for.

I balance my checkbook in excel. Each row has a spot for Date/Comments/Withdrawl/Deposit/Balance.

I'd like to search for a value in the comments (eg. daycare) and if that word exists, take the value from the Withdrawl cell and add it.

The idea is, for similar items I'll keep a running total.

Edit:
A1 = Date
B1 = Comments
C1 = Withdrawl
D1 = Deposit
E1 = Balance

1 reply

Posts
1934
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
July 21, 2021
144
adam73647, Good evening.

Try to do:

G2 --> DAYCARE

H2 --> =SUMIF(B2:B100, "*" & G2 & "*", C2:C100)

Adapt ranges to your reality.

Is that what you want?
I hope it helps.
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
2
Registration date
Tuesday January 3, 2017
Status
Member
Last seen
January 3, 2017

This did exactly what I was looking for. Thanks!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!