Formula Help!!!!! PLEASE

Brian_Anderson_AMR · 09/09/19

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 · 09/09/19

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

Give this slight modification a try.

Paul Newcome · 09/10/19

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)

Formula Help!!!!! PLEASE

Comments

Help Article Resources

Categories