Count if Date entered

[tra1a]

I am currently using this formula:

=(SUMPRODUCT(--(M20:M22="x"),--(J20:J22)))

So when an "x" is entered into cells M20:M22 counts J20:J22

Works lovely, however now I'd like to count not when an "x" is entered, but when a date is entered. Could be as simple as a not null, just not sure how to get it to work.

Thanks in advance.

 

[VoG]

Try

=SUMPRODUCT(--ISNUMBER(M20:M22),J20:J22)

 

[T. Valko]

I am currently using this formula:

=(SUMPRODUCT(--(M20:M22="x"),--(J20:J22)))

So when an "x" is entered into cells M20:M22 counts J20:J22

Works lovely, however now I'd like to count not when an "x" is entered, but when a date is entered. Could be as simple as a not null, just not sure how to get it to work.

Thanks in advance.

Maybe this...

=SUMIF(M20:M22,">0",J20:J22)

 

[tra1a]

Got it. Both should work.

Thanks!

 

[T. Valko]

Got it. Both should work.

Thanks!

You're welcome. Thanks for the feedback!