Formula Help Needed

		Microsoft Office Forums > Microsoft Excel > Excel
Formula Help Needed

FAQ

Mark Forums Read

Thread Tools

Display Modes

02-05-2018, 04:58 AM

ArviLaanemets ArviLaanemets is offline

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 949

Code:

=COUNTIFS(Risks!$K:$K,">= " & $Y$3,Risks!$K:$K,"<" & $AA$3+1)

Code:

=COUNTIFS(Risks!$Q:$Q,">=" & 3,Risks!$Q:$Q,"<=" & 4,Risks!$K:$K,">= " & $Y$3,Risks!$K:$K,"<" & $AA$3+1)

You had a wrong reference for end of month. And the formula for start of month returned string instead of date, so no match was found. Replace the formula in Y3 with

Code:

=DATEVALUE(1 & " " & U3 & " 2018")

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 07:20 AM.