Formula Help Needed

		Microsoft Office Forums > Microsoft Excel > Excel
Formula Help Needed

FAQ

Thread Tools

Display Modes

02-05-2018, 02:13 AM

OTPM

Windows 10 Formula Help Needed

Office 2016

Expert

Join Date: Apr 2011

Location: West Midlands

Posts: 981

Hi Xor

Brilliant works perfectly. My only other query is to check for values in column Q that are >=3 and/or <=4. I have tried both "AND" and "OR" but to no avail:

=SUMPRODUCT(ISNUMBER(Risks!$Q$5:$Q$20)*(AND(Risks! $Q5:$Q20>=3,Risks!$Q5:$Q20<=4)*(Risks!$K5:$K20>=(--("1/4/18")))*(Risks!$K5:$K20<=--("30/4/18"))))

Thanks for your help so far.
Tony

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula needed; I'm helpless	Ylli	Excel	10	12-13-2017 04:06 AM
Help needed with IF formula with a Vlookup	jonnie_rc	Excel	6	08-31-2017 01:27 PM
Complicated Formula Needed	midgetmogalle	Excel	14	01-29-2014 10:26 AM
Formula help needed	Cosmo	Excel	1	08-23-2012 11:50 AM
Excel formula needed.	Rod	Excel	1	08-03-2009 06:55 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:19 AM.