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.
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Domenic

MrExcel MVP
Joined
Mar 10, 2004
Messages
19,173
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!
 

Watch MrExcel Video

Forum statistics

Threads
1,099,560
Messages
5,469,427
Members
406,650
Latest member
cc4digital2

This Week's Hot Topics

Top