Roamingsmile
New Member
- Joined
- Feb 26, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi everyone, a new user here...
I’ve got a cell (g3) which contains the following-
COUNTIF(‘D1’!A41:N45, “1.1.2”)
1.1.2 can be entered unlimited times on the other sheet which Is fine and returns my count.
however this number needs to only be counted up to 2.
I gather it needs to be some sort of min(countif but I can’t work exactly.
this is one of many of my problems as I’m making (what I think lol) is a complex workbook! So if anyone wants to help, I’d be appreciative!
I’ve got a cell (g3) which contains the following-
COUNTIF(‘D1’!A41:N45, “1.1.2”)
1.1.2 can be entered unlimited times on the other sheet which Is fine and returns my count.
however this number needs to only be counted up to 2.
I gather it needs to be some sort of min(countif but I can’t work exactly.
this is one of many of my problems as I’m making (what I think lol) is a complex workbook! So if anyone wants to help, I’d be appreciative!