Jan 06 2019 03:37 AM
Hello I am trying to count the total number of games played by a particulat team using the COUNTIFS formula for multiple criteria over different ranges. Here is my data with the formula I have tried. Could you please tell me what I have got wrong?
Jan 06 2019 09:34 AM
Hi,
Please try this formula:
=SUM(IFERROR(COUNTIF(INDEX($C$2:$H$4,MATCH(A7,$A$2:$A$4,0),),"<>"&""),0),IFERROR(COUNTIF(INDEX($C$2:$H$4,MATCH(A7,$B$2:$B$4,0),),"<>"&""),0))
Hope that helps
Jan 17 2019 04:47 AM
Hi Haytham,
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.
Sharita
Jan 17 2019 10:07 AM
Hi,
I've updated the workbook with this formula instead:
=SUM(ISTEXT(IF(A7=$A$2:$A$4,$C$2:$H$4,0))+ISTEXT(IF(A7=$B$2:$B$4,$C$2:$H$4,0)))
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
Feb 13 2019 04:03 AM - edited Feb 13 2019 04:04 AM
hi!
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.
Feb 13 2019 08:16 AM
Hi,
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.
Regards