Hi All,
I am having trouble trying to count two numbers in more cell, the numbers are as follows 7849/2564, divided by a forwards slash. these number will be in other cells and I need a total of each number in the selected cells .. hope that makes sense ..
Counting the numbers individually isn't an issue but I cant seem to find anything that resolves the issue..
Current formula
=COUNTIFS($B$7:$D$19,N10)+COUNTIF($H$7:$K$19,N10)
Any ideas
Thanks in advance
Bookmarks