Help with formula please
I am trying to sum "Echo Specific CME" that fall between the dates of 5/1/2018 to 4/30/2021 on column "Date of CME". I keep getting an "Unparseable" error. Please let me know what I am doing wrong...
My formula: =SUMIFS([Echo Specific CME]:[Echo Specific CME], [Date of CME]:[Date of CME] >=(DATE(2018, 5, 1), OR([Date of CME]:[Date of CME] <=(DATE(2021, 4, 30)))
Columns on sheet: | Date of CME | Course Name |Echo Specific CME |Vascular Specific CME |
Thanks,
Roseanne
Best Answer
-
Just missing a couple of commas. I think you were trying to use the OR for the between the two dates, however you are really wanting an AND which is automatically built in to the SUMIFS function. Give this a shot.
=SUMIFS([Echo Specific CME]:[Echo Specific CME], [Date of CME]:[Date of CME], >=DATE(2018, 5, 1), [Date of CME]:[Date of CME], <=DATE(2021, 4, 30))
Answers
-
Just missing a couple of commas. I think you were trying to use the OR for the between the two dates, however you are really wanting an AND which is automatically built in to the SUMIFS function. Give this a shot.
=SUMIFS([Echo Specific CME]:[Echo Specific CME], [Date of CME]:[Date of CME], >=DATE(2018, 5, 1), [Date of CME]:[Date of CME], <=DATE(2021, 4, 30))
-
That worked! How would you get it to display 0.00 if staff member has no CME during that period?
Thanks,
Roseanne
-
@Roseanne Gerringer , It should equal to zero if there are no CME's populated within that timeframe.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.6K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!