Question about searching a spreadsheet by month

[Karl E]

In Microsoft Excel,I need to write a formula that works this way:

1. If (cell E1 to E13000) is between january 1 and january31
   
2. And if Column F has"Employee Computer" in the cell

Sumthe time elapsed which is recorded in column J for all the rows in whichcondition1 and condition 2 were met.

Below is the formula I came up with.

=SUMIFS(Usage!$J$1000:$J$13000,Usage!$E$1000:$E$13000,”>=1/1/2019″,Usage!$E$1000:$E$13000,”<=1/31/2019″,Usage!$F$1000:$F$13000,"EmployeeComputer")

I keep getting an error message


And it also highlights 2019 on the formula (including thelast quotation mark.

Does anyone know what I’m doing wrong??

 

[James006]

Hi,

In your E column, do your store your date values as Text or as Numbers ...?

 

[Karl E]

Its formatted as Date. the example shows *3/14/2012. Should I change it to text?