Nov 07 2021 08:49 AM
I am trying to make the Cell W15 Calculate when the words in V2 and W2 appear in the same row between Column B and F and then do the same with V2, W2, X2 but for X15
Nov 07 2021 09:13 AM
=SUM(COUNTIF(B2:F2,V2:W2))
Enter formula as arrayformula with ctrl+shift+enter if you don't work with office365 or 2021.
Is this what you are looking for? Please compare attached file.
Nov 07 2021 09:22 AM
Nov 07 2021 09:25 AM
Nov 07 2021 09:34 AM
=SUM(COUNTIF(B2:F80,V2:X2))
This formula counts number of all words of cells V2:X2 that appear in range B2:F80 in my spreadsheet.
Can you communicate the formula you entered or can you upload your spreadsheet? This would help trying to solve your request.
Nov 07 2021 09:39 AM
@OliverScheurich I attached my spreadsheet. Seems to be only identifying when a row has 1 of the variables rather than all of them
Nov 07 2021 09:48 AM
Which Office version do you work with? If you don't work with Office365 or 2021 you have to enter arrayformulas with ctrl+shift+enter. After doing this formulas return 5, 15 and 22.
Nov 07 2021 09:58 AM
Nov 07 2021 10:20 AM
See attached spreadsheet with my suggestion.
Nov 07 2021 10:59 AM
Nov 07 2021 11:08 AM
SolutionSee attached file.
Nov 07 2021 11:14 AM
Nov 07 2021 11:26 AM
Glad it helped. I forgot the 3 unit combo formula.
Nov 07 2021 12:01 PM
Nov 07 2021 11:08 AM
Solution