Forum Discussion
Solved
I am trying to make the Cell W15 Calculate when the words in V2 and W2 appear in the same row
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
See attached file.
=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.
Thankyou for the reply!
Not quite as when i plugged it into my own spreadsheet, it will only count the one row so i changed the F2 to F80 as there are 80 rows but then it seems to be counting one extra row which i think is V2:W2 so i just added a -1 at the end of the function
Not quite as when i plugged it into my own spreadsheet, it will only count the one row so i changed the F2 to F80 as there are 80 rows but then it seems to be counting one extra row which i think is V2:W2 so i just added a -1 at the end of the function
- Also i am unable to then use this to try and add the X3 column as i tried adding X2 to the formula
=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.
OliverScheurich I attached my spreadsheet. Seems to be only identifying when a row has 1 of the variables rather than all of them