excel - Using month qualification in SUMIFS statment -


here's i'm looking for.... trying sum count of worksheet 'results 2013' column g items

if cell matches "canada" if cell e (date) july 

having trouble date portion of sumifs statement below.

sumifs('results 2013'!$g$2:$g$510,'results 2013'!$a2:$a$510     ,"=canada",'results 2013'!$e2:$e510,month('results 2013'!$e2:$e510)=7) 

example value of "results 2013"$e$480

i try formula, , provides "january" incorrect.

=text(month('results 2013'!$e$480),"mmmm") 

however, formula, results in true or 1

=if(month('results 2013'!$e$480)=7,1,0) 

the simplest solution add column month using month function compute values, , refer new column in sumifs.


Comments

Popular posts from this blog

Detect support for Shoutcast ICY MP3 without navigator.userAgent in Firefox? -

web - SVG not rendering properly in Firefox -

java - JavaFX 2 slider labelFormatter not being used -