• 516K Members
• 6,443 Online
• 612K Conversations

New Contributor

Excel Countifs

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?

7 Replies

Re: Excel Countifs

Hi,

=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

Re: Excel Countifs

Hi Haytham,

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

Highlighted

Re: Excel Countifs

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

Re: Excel Countifs

Thank you Haytham, that worked.

Regards

Sharita

Re: Excel Countifs

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.

Re: Excel Countifs

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

Re: Excel Countifs

Related Conversations
COUNTIF not working
sme527 in Excel on
10 Replies
Totaling using two sets of data
dazedandconfused in Excel on
2 Replies
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies