Hi,
I am using the following COUNTIF formula that has been working fine, but now in the final criteria I need it to look for a numbers between 18 and 22 inclusive, not just greater than 18. The various options I have tried do not seem to work. I am a basic excel user so any help would be appreciated.
=COUNTIFS('Risk Register'!$E$4:$E$920,"Live",'Risk Register'!$P$4:$P$920,"Management",'Risk Register'!$M$4:$M$920,">=18")
Many thanks.
Last edited by az6781; 05-10-2015 at 01:22 PM. Reason: Solved
Hello
You should just need to repeat the final Criteria range with the <=22 Criteria:
Formula:
COUNTIFS('Risk Register'!$E$4:$E$920,"Live",'Risk Register'!$P$4:$P$920,"Management",'Risk Register'!$M$4:$M$920,">=18",'Risk Register'!$M$4:$M$920,"<=22")
DBY
Thank you, not sure what I was doing wrong to not get that to work, but it is sorted now.
Hi
in c15 enter this
Copied down and across
=SUMPRODUCT(($A$2:$A$13=$A15)*($B$2:$B$13=$B15)*(C$2:C$13))
Mark the thread as solved if you are satisfied with the answer.
In your first post under the thread tools.
Mahju
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks