Forum Discussion
Solved
Help required - multiple formulas needed
Good day, I have the folloeing problems with an example workbook attached, that I was wondering whether anyone can help with. It involves formulas which I cannot get right/don't understand. Many ...
In B2:
=IF(COUNTIFS(Sheet2!$A$2:$A$31,A2,Sheet2!$B$2:$B$31,"banana"),"yes","no")
In C2:
=IF(COUNTIFS(Sheet2!$A$2:$A$31,A2,Sheet2!$C$2:$C$31,"vegetable")>2,"yes","no")
Fill down.
Patrick2788
This is giving a response of 'yes' for each cell, rather than just a 'yes' against c3
This is giving a response of 'yes' for each cell, rather than just a 'yes' against c3
In B2:
=IF(COUNTIFS(Sheet2!$A$2:$A$31,A2,Sheet2!$B$2:$B$31,"banana"),"yes","no")
In C2:
=IF(COUNTIFS(Sheet2!$A$2:$A$31,A2,Sheet2!$C$2:$C$31,"vegetable")>2,"yes","no")
Fill down.
- HansVogelaar
Many thanks Hans, this works on the example. I will run this on the real workbook tomorrow and test. Thanks again, I'm a noob to the IFS formula, although much better than last year (I still use that VBA code you wrote).