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,
Farhan MahmoodManager Finance & AccountsAsked:
Who is Participating?
 
Bill PrewCommented:
And to do it dynamically tied to C1 value you can do:

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

Open in new window


»bp
0
 
AlanConsultantCommented:
Hi Farhan,

Try this:

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

Open in new window



Alan.
0
 
Rob HensonFinance 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
 
Bill PrewCommented:
Just style.
0
 
AlanConsultantCommented:
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.