for everytime a slot contains "word" count amount in another slot

[itge13]

hey guys I try to achieve that, but are pretty new. Any Ideas?

E.g. there is a list of names in F1:F100 and for each of them a number in G1:G100
F3 and F5 contain "word"
G3 and G5 contain the values 10 and 5
the formula should now give me the amount of G3+G5 = 15

or

F8, F14 and F15 contain "word"
G8, G14 and G15 contain the values 10, 5 and 5
the formula should now give me the amount 20

[FlameRetired]

Hello itge13. Welcome to the forum.

Try this ... you may have to change the "," argument separator to ";" for your regional settings.

Please Login or Register  to view this content.

[Fluff13]

Another option

Please Login or Register  to view this content.

[FlameRetired]

@ Fluff
Yes. Better.


Also waiting for OP feedback to see if input is limited to just those cells specifically ... ie what if F6, F17 etc also contain "word".

[Fluff13]

Also waiting to see if "word" actually means "word", or something completely different.

[FlameRetired]

Yup!

Threads always full of surprises.

[Fluff13]

Oh, yes.
keeps us on our toes

[itge13]

Thanks for the answers guys and sorry for late respond. I found it out on other ways and forgot about it here. PS: IT WORKS

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[Fluff13]

Thanks for the answers guys and sorry for late respond. I found it out on other ways and forgot about it here. PS: IT WORKS

Glad we could help & thanks for the feedback

[FlameRetired]

Same here as well.