Date Comparrision in SUMIF Formula

[jmyeti]

I'm trying to use the SUMIF function to search a column (G) of dates for only the rows that are past today's date, then add that row's value in a different column (M) to whatever existing sum it has reached so far. The overall goal is to only add the product counts in column M together to get a total product count for every instance that has a date after today's date.

Here is what I have so far, but it doesn't do any summing and just returns zero: =SUMIF($G6:$G348, DATEVALUE($G6:$G348)>DATEVALUE($C$1), M6:M348)

Thanks!

 

[VoG]

Try

=SUMIF($G6:$G348, ">"&C1, M6:M348)

 

[jmyeti]

Thanks Peter, that worked perfectly! I do have some blank rows in the date column. Do I just use AND("",">"&$C$1) in order to capture those row's data as well?

 

[VoG]

I think that would ignore blanks but if not try

=SUMPRODUCT(--(G6:G348<>""),--(G6:G348>C1),M6:M348)

 

[Jon von der Heyden]

Do you mean you want to add blanks too?

=SUMPRODUCT(SUMIF($G6:$G348,CHOOSE({1;2},">"&C1,""),M6:M348))

 

[jmyeti]

Unfortunately, that did not grab the NULL date rows. Any other ideas?

 

[jmyeti]

No, I just want to be able to include the rows that I haven't loaded dates for yet, as well as the rows that have dates later than today. Does that make sense? For some accounts, we don't have dates yet, but we know the predicted product count so we want to know what the total forecast will be of counts in column M.

 

[VoG]

Did you try Jon's formula? It works for me.

 

[jmyeti]

That seems to have done it. Thanks so much for both of your help!