sumproducts with counta

[dmheller]

All,
ran into a snag and it might be the 2 combined or the ref cell. Hope someone can help. Here is what I have.
=SUMPRODUCT(--(INT('Line 3 data copy'!B4:B44739)=INT('Line 3 calc Sheet'!B3)),COUNTA('Line 3 data copy'!O43:O48576))
Returns #value
B4 is a date 8/1/17 11:15
B3 is a date 8/1/17
random words go into O43 down.
I will say this, B4 is this

=IF(ISBLANK('Line 3'!D4),"",IF('Line 3'!D4<'Line 3'!$A$14,'Line 3'!D4,""))
that is back to another date on a different sheet.

 

[Aladin Akyurek]

Perhaps you are looking for this?

=SUMPRODUCT(--(INT('Line 3 data copy'!B4:B44739)=INT('Line 3 calc Sheet'!B3)),--ISNUMBER(SEARCH("?*",'Line 3 data copy'!O43:O48576)))

 

[dmheller]

That returns value as well. It wont be a number in O, it will be text I see the text search for anything with "?*" but that's not finding any values.

 

[Aladin Akyurek]

That returns value as well. It wont be a number in O, it will be text I see the text search for anything with "?*" but that's not finding any values.

The ranges are not the same size...

=SUMPRODUCT(--(INT('Line 3 data copy'!B4:B44739)=INT('Line 3 calc Sheet'!B3)),--ISNUMBER(SEARCH("?*",'Line 3 data copy'!O4:O44739)))

If the formula must reside in Line Calc Sheet, then:

=SUMPRODUCT(--(INT('Line 3 data copy'!B4:B44739)=INT(B3)),--ISNUMBER(SEARCH("?*",'Line 3 data copy'!O4:O44739)))

 

[dmheller]

Same results. I am just going to add a column that adds all comments for the day and then copy that over, this is making me angry. I thought I would simplify it and I failed. Thank you for your help but there is probably something wrong with my data.

 

[dmheller]

It was an error on my part. Thank you for this, it works now. I changed your equation but forgot to make the column size match. It works. Thank you

 

[Aladin Akyurek]

It was an error on my part. Thank you for this, it works now. I changed your equation but forgot to make the column size match. It works. Thank you

Glad to see you sorted it out. Thanks for the update.