LinkBack URL
About LinkBacks
Hi,
can anyone help me, I need to add one more criteria to my formula
On the 2nd condition, I want to make it ">=2 and <3"
Please Login or Register to view this content.
Hi,
can anyone help me, I need to add one more criteria to my formula
On the 2nd condition, I want to make it ">=2 and <3"
Please Login or Register to view this content.
1. Thank those who have helped you by clicking the Star * below the post.
2. Please mark your post [SOLVED] if it has been answered satisfactorily.
Sincerely,
Farid
Just add another criteria
=COUNTIFS(C2:C4623,B2,E2:E4623,"<3",E2:E4623,">=2")
Hi Jonmo1,
Thanks a lot. working fine.
initially, I saw few samples use like this, =SUM(COUNTIFS(C2:C4623,B2,E2:E4623,{">=2","<3"})) but it does not work
http://www.excelforum.com/excel-form...ml#post3372270
what went wrong with this?
Last edited by Faridwahidi; 08-23-2015 at 12:44 PM.
You're welcome.
That syntax works like an OR.
Reads like E >=2 OR E <3
What you needed was AND, which countifs does by already design.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks