So I’m trying to use a basic SUMIF function between two charts in excel. I’d like the function to sum all rows that has the year 2018 in the date column. When I write the SUMIF function with criteria “*2018*”, the function returns no value, but if I insert a specific date from the chart, f.ex “4.12.2018”, the function returns the appropriate value. I can’t for the life of me figure what I’m doing wrong.
If you're the first out the door, that's not called panicking
Study together. Pass together.
Join the world's largest online community of CFA, CAIA and FRM candidates.