Help with formula please

Roseanne Gerringer

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

John Jonassen

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))

John Jonassen

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))

Roseanne Gerringer

That worked! How would you get it to display 0.00 if staff member has no CME during that period?

Thanks,

Roseanne

John Jonassen

@Roseanne Gerringer , It should equal to zero if there are no CME's populated within that timeframe.