I am trying to do a SUMIF formula where I’m trying to sum the square feet of cells (sum_range column) based on the criteria_range of having the year 2017 (e.g., if there were three different cells in the criteria_range column with dates that looked like 3/1/2017, 2/1/2017 and 9/1/2017, then they would fit the criteria and I would have the function add up their respective square footages to give me my desired answer).
This is the function I have tried so far to find the sum of the square footages for cells ending in 2017: =SUMIF(G:G,"*2017",E:E)
I thought this would work because G:G is my column that I want to analyze, “*2017” is my criteria with the asterisk wildcard so that it only selects dates ending in 2017, and E:E is my sum range (i.e., the column with the square footages).
However, when I plug this equation in, I get 0.00. There must be some mistake because I don’t know where I am going wrong.
Bookmarks