Formula Help!!!!! PLEASE

Brian_Anderson_AMR

I have a data set with a bunch of dates 

09/03/19

09/04/19

08/19/19

07/01/19

You get the idea.... 

Im trying to get a count of "incidents" by month... but I cant get the formula to work!!! 

July = 10 

Ive tried... (below) and many others... 

=COUNTIF({(NEW) Support Request (USER) Range 10}, MONTH({(NEW) Support Request (USER) Range 10}}7)) 

#Unparseable 

=SUMIF({(NEW) Support Request (USER) Range 10}, MONTH({(NEW) Support Request (USER) Range 10}7))

#Unparseable 

 

Mike Wilday

=COUNTIF({(NEW) Support Request (USER) Range 10}, MONTH({(NEW) Support Request (USER) Range 10}) = 7)) 

Give this slight modification a try.

Paul Newcome

You don't want to look at the MONTH for the ENTIRE range as a whole. You want to look at the entire range yes, but on an individual cell by cell basis.

 

=SUMIF({(NEW) Support Request (USER) Range 10}, MONTH(@cell) = 7)