need help with formula
 

I am trying to accomplish the following;

If the dates 1 and 2 match or date 2 is earlier than date 1 add 20 points to
the total; if both dates dont match or the date 2 is later than than date 1
no additional points are added to the total


=IFSUM(I7M7)=N7+20,(I7)<(I7)=N7+0

CELL
(I7) DATE
(M7) DATE
(N7) SUM TOTAL =SUM(N1:N6)

PJEAN

need help with formula
 

On Fri, 19 Sep 2008 21:16:00 -0700, PJEAN
wrote:

I am trying to accomplish the following;

If the dates 1 and 2 match or date 2 is earlier than date 1 add 20 points to
the total; if both dates don’t match or the date 2 is later than than date 1
no additional points are added to the total


=IFSUM(I7M7)=N7+20,(I7)<(I7)=N7+0

CELL
(I7) DATE
(M7) DATE
(N7) SUM TOTAL =SUM(N1:N6)

PJEAN



Try this formula in cell N7:

=SUM(N1:N6)+20*(M7<=I7)

Hope this helps / Lars-Åke

need help with formula
 

Thanks

"Lars-Ã…ke Aspelin" wrote:

On Fri, 19 Sep 2008 21:16:00 -0700, PJEAN
wrote:

I am trying to accomplish the following;

If the dates 1 and 2 match or date 2 is earlier than date 1 add 20 points to
the total; if both dates dont match or the date 2 is later than than date 1
no additional points are added to the total


=IFSUM(I7M7)=N7+20,(I7)<(I7)=N7+0

CELL
(I7) DATE
(M7) DATE
(N7) SUM TOTAL =SUM(N1:N6)

PJEAN



Try this formula in cell N7:

=SUM(N1:N6)+20*(M7<=I7)

Hope this helps / Lars-Ã…ke