01-06-2019 03:37 AM
01-17-2019 04:47 AM
Thankyou for your reply and sorry for my delay in replying as I just got back.
I have tried the formula, but it only seems to count the occurances for the first instance it matches the criteria. So for example if I had Team A playing many different teams, it only counts the first row. Is there a way for it to carry on counting the occurances?
Many thanks for your time. I much appreciate it.
01-17-2019 10:07 AM
I've updated the workbook with this formula instead:
Please note that this formula is an array formula, so you have to press Ctrl+Shift+Enter to enter it in order to get the correct result, and do the same thing each time you enter this formula.
Hope that helps
02-13-2019 04:03 AM - edited 02-13-2019 04:04 AM
I have a doubt, I need to get the count of Present "P" from the criteria of India Operation in Dubai and Specific date.
Ex: On 2 feb no. of presents in India Operation (Dubai). Please advise the formula.
thanks in advance.
02-13-2019 08:16 AM
I need a sample worksheet to correctly fit the formula on your data.
But you should re-post this request in a separate conversation, this is for better visibility.