Word text +1 tally with cell placement.

[ArmyGuy45]

I have a fun one for you guys. I don't know if this is possible in Excel but I would like to see what you guys think.

I am looking for a formula or multiple formulas to perform an If/Then statement, adding and dividing. Example listed below.

If O8 = 'Y' then perform XXXX, otherwise, do nothing.

XXXX= in Y8 search for word 'apple' and add tally to AA46, in Y8 search for word 'orange' and add tally to AA47, in Y8 search for word 'banana' and add tally to AA48.

Take AA46/Y46 and put results in AB46.

If this could be put into on cell and perform all the needed actions that would be appreciated, otherwise, multiple cell formulas is ok. Thanks!

AG45

[Ron Coderre]

Formulas are unable to change the values of other cells. So, if you're hoping to have a value in AA46 (eg. 100) and use a formula to add to that value...that can't happen with formulas, but CAN happen with VBA.

However, if you need AA46 to contain a formula that tallies up some value...that CAN happen.

Which of those do you need?

[ArmyGuy45]

AA46-48 have no value at all. They are more or less a gathering of all the tallies throughout the page. I just need to find a formula that can perform this "XXXX= in Y8 search for word 'apple' and add tally to AA46, in Y8 search for word 'orange' and add tally to AA47, in Y8 search for word 'banana' and add tally to AA48" that I can paste to multiple rows that will put a total tally in AA46-48 based on the word category (apples, oranges, etc).

Does that make sense?

[gak67]

Not really. Can you upload an example file?

[ArmyGuy45]

I hope this helps.


Example.xlsx

[Ron Coderre]

Using your posted workbook...I *think* this is what you're looking for:

Please Login or Register  to view this content.

Copy that formula down as far as you need.

EDITED TO INCLUDE THIS ALTERNATIVE:
Since your example uses an Excel Table...you could use this formula (which will automatically expand and contract the referenced fields to match the table contents:

Please Login or Register  to view this content.

Is that something you can work with?

[AliGW]

In G10:

=COUNTIFS(A3:A8,"Y",E3:E8,"*Apples*")

Adapt for the other two cells.

[ArmyGuy45]

Thank you all! It works for my grocery list example, now lets see the real thing!

[ArmyGuy45]

So far it is working!!! Thank you all. It looks like I was over complicating things from the beginning.

[Ron Coderre]

Glad you got something you can use!

Be sure to mark this thread as SOLVED (from the Thread Tools menu)

[ArmyGuy45]

Glad you got something you can use!

Be sure to mark this thread as SOLVED (from the Thread Tools menu)

Just did. Thanks!