Countif + index + match

[JMG1031]

So I am trying to count the number of times a specified number (1) occurs in columns with the header of "WX". There are multiple colums that have the header WX. This is the formula I have entered in to Q83

=COUNTIF(INDEX(E48:AFI58,MATCH(A48,E48:AFI48,0)),1)

Sort of new to Excel but pretty good are reverse engineering the formulas and learning that way but looking through the threads have just left me stumped errors when trying some of the expamples that were listed.

Also not sure how to attach the sheet to this post. I know it would help out if I could do so.

V/r
Jeff

 

[Aladin Akyurek]

MATCH requires a vector, not a matrix; so that formula won't succeed. Try rather something like...

=SUM(IF(E48:AFI48=A48,IF(E49:AFI58=1,1)))

which must be confirmed with control+shift+enter, not just enter.

 

[JMG1031]

MATCH requires a vector, not a matrix; so that formula won't succeed. Try rather something like...

=SUM(IF(E48:AFI48=A48,IF(E49:AFI58=1,1)))

which must be confirmed with control+shift+enter, not just enter.

It keeps telling me "Array formulas are not valid in merged cells" but I don't have any merged cells in the area that I am working with. I made sure to not have any after the first time getting this error. Any suggestions. I am working with Excel 2010

Thank you for your time and assistance.

V/r
Jeff

 

[JMG1031]

This was a double post

 

[Aladin Akyurek]

It keeps telling me "Array formulas are not valid in merged cells" but I don't have any merged cells in the area that I am working with. I made sure to not have any after the first time getting this error. Any suggestions. I am working with Excel 2010

Thank you for your time and assistance.

V/r
Jeff

JAD	3			LAD	JAD	JAD	NAD	VAD
				1	1	2	0	6
				2	0	1	4	2
				0	1	2	3	4

<tbody>
</tbody>

A48: JAD

Only the cells shown above contain data in order to keep the exhibit small.

B48, control+shift+enter (CSE), not just enter:

=SUM(IF(E48:AFI48=A48,IF(E49:AFI58=1,1)))

CSE: Press down the control and shift keys at the same time, while you hit the enter key.