Excel Formula Help

Dear Experts,

Please guide me on Following Formula in Countif. i have Range Range A1:A5 = "F" and B1:B5 = "M and Criteria is at C1 = "FM" i am Using Formula Countif(A1:A5&B1:B5,C1) ans must be 5 but not working with Single enter or Array Formula Ctrl+Shif+Enter Please guide how to figure it out.

Regards,
Who is Participating?

Commented:
And to do it dynamically tied to C1 value you can do:

``````=COUNTIFS(A1:A5,"="&LEFT(C1,1),B1:B5,"="&RIGHT(C1,1))
``````

»bp
0

ConsultantCommented:
Hi Farhan,

Try this:

``````=COUNTIFS(A1:A5,"F",B1:B5,"M")
``````

Alan.
0

Finance AnalystCommented:
@Bill:  Why the "="&LEFT  and "="&RIGHT

Just this will do the same:

=COUNTIFS(A1:A5,LEFT(C1,1),B1:B5,RIGHT(C1,1))
0

Commented:
Just style.
0

ConsultantCommented:
Solutions offered work
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.