sumproduct and countif question

reducedjuice

Board Regular
Joined
Oct 29, 2008
Messages
99
Okay, now let's make sure that the dates are true date values. So, for example, the following should return TRUE...

=ISNUMBER(Sheet1!B2)

=ISNUMBER(Sheet1!C2)

=ISNUMBER(Sheet2!A2)
=ISNUMBER(Sheet1!B2) - TRUE

=ISNUMBER(Sheet1!C2) - TRUE

=ISNUMBER(Sheet2!A2) - FALSE

I suppose that's part of the problem then... I need to match the formatting of that column to that of the other two, correct? Or vice versa I guess.
 

Domenic

MrExcel MVP
Joined
Mar 10, 2004
Messages
19,036
It looks like the date in Sheet2!A2 is being recognized as text. The following should convert the date to a true date value...

1) Select an empty cell

2) Edit > Copy

3) Select Sheet2!A2 (or the entire column to convert them to true date values)

4) Edit > Paste Special > Add > Ok

Does this help?
 

reducedjuice

Board Regular
Joined
Oct 29, 2008
Messages
99
It looks like the date in Sheet2!A2 is being recognized as text. The following should convert the date to a true date value...

1) Select an empty cell

2) Edit > Copy

3) Select Sheet2!A2 (or the entire column to convert them to true date values)

4) Edit > Paste Special > Add > Ok

Does this help?
That does help! It converted it and I ran the test you gave me which returned TRUE this time. I ran my SUMIFS formula and it returned results... I took a small sample and manually calculated to ensure it was done properly and it is!

Thanks for your help and patience!
 

Forum statistics

Threads
1,085,075
Messages
5,381,558
Members
401,744
Latest member
Schoen

Some videos you may like

This Week's Hot Topics

Top