Use of the wild card???

[Daniellel]

Hi,

I need to do the sum below but my raw data is in date format with different days (14 May 2010, 16 May 2010 etc)

=SUMPRODUCT(--('Raw Data'!$G$1:$G$9549="May 2010"),--('Raw Data'!$B$1:$B$9549=$A34))

I think i need to use a wild card but i have never used this so dont know how, i need to coult all entries that have "May 2010" within the G column...

Please Help!

 

[Aladin Akyurek]

Hi,

I need to do the sum below but my raw data is in date format with different days (14 May 2010, 16 May 2010 etc)

=SUMPRODUCT(--('Raw Data'!$G$1:$G$9549="May 2010"),--('Raw Data'!$B$1:$B$9549=$A34))

I think i need to use a wild card but i have never used this so dont know how, i need to coult all entries that have "May 2010" within the G column...

Please Help!

No need for wild card. Try rather...

=SUMPRODUCT(--(TEXT('Raw Data'!$G$1:$G$9549,"mmm yyyy")="May 2010"),--('Raw Data'!$B$1:$B$9549=$A34))

 

[Yahya]

try this

=SUMPRODUCT(--(ISNUMBER(SEARCH("May 2010",'Raw Data'!G1:G9549))),--('Raw Data'!$B$1:$B$9549=$A34))

 

[Daniellel]

No need for wild card. Try rather...

=SUMPRODUCT(--(TEXT('Raw Data'!$G$1:$G$9549,"mmm yyyy")="May 2010"),--('Raw Data'!$B$1:$B$9549=$A34))

Thank you so much for this, it has returned a number of 2 but there are over 58 entries. Should i change the format of Column G as it is currently at "General"

 

[Daniellel]

try this

=SUMPRODUCT(--(ISNUMBER(SEARCH("May 2010",'Raw Data'!G1:G9549))),--('Raw Data'!$B$1:$B$9549=$A34))

Again, this is only returning 2 results as per my other comment?

 

[Aladin Akyurek]

Thank you so much for this, it has returned a number of 2 but there are over 58 entries. Should i change the format of Column G as it is currently at "General"

'Raw Data'!$G$1:$G$9549 must house true dates.

What do you get when you would run on Raw Data, say, in K1 downwards:

=ISNUMBER(G1)