Does anyone know if the criteria in a SUMIF function must
be a specific value as oppsed to a cell reference. I've
been trying to get the following to work:
A B C D E F
1 START Sep 1 Oct 1 Nov 1 Dec 1
2 Program A Oct 1 34 46 52 25
3 Program B Nov 1 42 29 32 21

For each program, I want to sum only the values that come
AFTER the start date. Since the data changes every month,
I need a way to set up the criteria to reference the START
column to identify the START date. I've been writing the
formula as:

=SUMIF(B1:F1,"B2",B2:F2)
This return a value of "0"
If I substitute the actual value for the cell reference:
=SUMIF(B1:F1, "Oct 1", B2:F2)
the formula works, but it doesn't solve my problem since
the program list (and start dates) change every month.

Should I give up on SUMIF and try this another way??? Any
suggestions???

=SUMIF(B1:F1,""&B2,B2:F2)


--

HTH

RP
(remove nothere from the email address if mailing direct)


"stacey" wrote in message
...
Does anyone know if the criteria in a SUMIF function must
be a specific value as oppsed to a cell reference. I've
been trying to get the following to work:
A B C D E F
1 START Sep 1 Oct 1 Nov 1 Dec 1
2 Program A Oct 1 34 46 52 25
3 Program B Nov 1 42 29 32 21

For each program, I want to sum only the values that come
AFTER the start date. Since the data changes every month,
I need a way to set up the criteria to reference the START
column to identify the START date. I've been writing the
formula as:

=SUMIF(B1:F1,"B2",B2:F2)
This return a value of "0"
If I substitute the actual value for the cell reference:
=SUMIF(B1:F1, "Oct 1", B2:F2)
the formula works, but it doesn't solve my problem since
the program list (and start dates) change every month.

Should I give up on SUMIF and try this another way??? Any
suggestions???

Hi
=SUMIF(B1:F1,""&B2,B2:F2)

--
Regards
Frank Kabel
Frankfurt, Germany
"stacey" schrieb im Newsbeitrag
...
Does anyone know if the criteria in a SUMIF function must
be a specific value as oppsed to a cell reference. I've
been trying to get the following to work:
A B C D E F
1 START Sep 1 Oct 1 Nov 1 Dec 1
2 Program A Oct 1 34 46 52 25
3 Program B Nov 1 42 29 32 21

For each program, I want to sum only the values that come
AFTER the start date. Since the data changes every month,
I need a way to set up the criteria to reference the START
column to identify the START date. I've been writing the
formula as:

=SUMIF(B1:F1,"B2",B2:F2)
This return a value of "0"
If I substitute the actual value for the cell reference:
=SUMIF(B1:F1, "Oct 1", B2:F2)
the formula works, but it doesn't solve my problem since
the program list (and start dates) change every month.

Should I give up on SUMIF and try this another way??? Any
suggestions???

Thank You!!!!!!!!!!!!
-----Original Message-----
Hi
=SUMIF(B1:F1,""&B2,B2:F2)

--
Regards
Frank Kabel
Frankfurt, Germany
"stacey" schrieb im
Newsbeitrag
...
Does anyone know if the criteria in a SUMIF function
must
be a specific value as oppsed to a cell reference. I've
been trying to get the following to work:
A B C D E F
1 START Sep 1 Oct 1 Nov 1 Dec 1
2 Program A Oct 1 34 46 52 25
3 Program B Nov 1 42 29 32 21

For each program, I want to sum only the values that
come
AFTER the start date. Since the data changes every
month,
I need a way to set up the criteria to reference the
START
column to identify the START date. I've been writing
the
formula as:

=SUMIF(B1:F1,"B2",B2:F2)
This return a value of "0"
If I substitute the actual value for the cell reference:
=SUMIF(B1:F1, "Oct 1", B2:F2)
the formula works, but it doesn't solve my problem since
the program list (and start dates) change every month.

Should I give up on SUMIF and try this another way???
Any
suggestions???



.