summing automatically if in cell, sum in cell text to it

**floris3000** · 02-24-2017, 03:45 PM

Hey,

When I add a item like 'red', I want that excel counts it automatically in the cell next to it.
Is that possible and which formula I can use for it?
And do you have a source, so I can help myself further with this kind of formulas?

I added a wetransfer link, because I cannot upload any attachments.

Kind regards,
Floris
Screen Shot 2017-02-24 at 20.30.16.png
https://we.tl/icjxK2p92D

=SUMIF(C5:C11;"*"&F7&"*";D5:D11)

**Glenn Kennedy** · 02-24-2017, 09:12 PM

With the first Keyword in E6 and the second keyword (if any) in F6, use this in G6, copied down:

=SUMPRODUCT(ISNUMBER(SEARCH(F6,$C$5:$C$11))*ISNUMBER(SEARCH(G6,$C$5:$C$11))*$D$5:$D$11)

Next time, please attach a sheet directly.

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.