Previous Topic Next Topic

Search for a Keyword. Add Value from another cell.

Solved/Closed
adam73647 Posts 2 Registration date Tuesday January 3, 2017 Status Member Last seen January 3, 2017 - Updated by adam73647 on 3/01/17 at 01:58 PM
adam73647 Posts 2 Registration date Tuesday January 3, 2017 Status Member Last seen January 3, 2017 - Jan 3, 2017 at 10:09 PM
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
Related:

1 response

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jan 3, 2017 at 04:11 PM
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
adam73647 Posts 2 Registration date Tuesday January 3, 2017 Status Member Last seen January 3, 2017
Jan 3, 2017 at 10:09 PM
This did exactly what I was looking for. Thanks!
0

Similar discussions

If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Search in conversations on Messenger not possible anymore
GentseGast -
kiransaini88 -

3 responses