ExcelBanter - SUMIF or SUMNPRODUCT Help

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SUMIF or SUMNPRODUCT Help (https://www.excelbanter.com/excel-worksheet-functions/6098-sumif-sumnproduct-help.html)

LOU

SUMIF or SUMNPRODUCT Help

Hello!

how do I write this one?

B1 thru B300 has date values
F1 thru F300 has the dollar values

I need a formula to sum them up by date range using the between or <..
SUMIF(B1:B300,"BETWEEN 10/01/2004 AND 11/01/2004", F1:F300) ?????
SUMPRODUCT..?
HELP.
Thank you.

Frank Kabel

Hi
try:
=SUMIF(B1:B300,"=" & DATE(2004,10,1), F1:F300) -SUMIF(B1:B300,"=" &
DATE(2004,11,1), F1:F300)

"LOU" wrote:

Hello!

how do I write this one?

B1 thru B300 has date values
F1 thru F300 has the dollar values

I need a formula to sum them up by date range using the between or <..
SUMIF(B1:B300,"BETWEEN 10/01/2004 AND 11/01/2004", F1:F300) ?????
SUMPRODUCT..?
HELP.
Thank you.

LOU

Thank you frank, worked great.

"Frank Kabel" wrote:

Hi
try:
=SUMIF(B1:B300,"=" & DATE(2004,10,1), F1:F300) -SUMIF(B1:B300,"=" &
DATE(2004,11,1), F1:F300)

"LOU" wrote:

Hello!

how do I write this one?

B1 thru B300 has date values
F1 thru F300 has the dollar values

I need a formula to sum them up by date range using the between or <..
SUMIF(B1:B300,"BETWEEN 10/01/2004 AND 11/01/2004", F1:F300) ?????
SUMPRODUCT..?
HELP.
Thank you.

Maddie

How would you add on more criterial into this?? Example: Pulls the date
range of these cells if it also is labeled PP??
B1:B300 = DATE RANGES
C1:C200 = PP OR MPU

I only want it to pull those labeled PP for each work week.

"Frank Kabel" wrote:

Hi
try:
=SUMIF(B1:B300,"=" & DATE(2004,10,1), F1:F300) -SUMIF(B1:B300,"=" &
DATE(2004,11,1), F1:F300)

"LOU" wrote:

Hello!

how do I write this one?

B1 thru B300 has date values
F1 thru F300 has the dollar values

I need a formula to sum them up by date range using the between or <..
SUMIF(B1:B300,"BETWEEN 10/01/2004 AND 11/01/2004", F1:F300) ?????
SUMPRODUCT..?
HELP.
Thank you.

Bob Phillips

See your other post.

--

HTH

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

"Maddie" wrote in message
...
How would you add on more criterial into this?? Example: Pulls the date
range of these cells if it also is labeled PP??
B1:B300 = DATE RANGES
C1:C200 = PP OR MPU

I only want it to pull those labeled PP for each work week.

"Frank Kabel" wrote:

Hi
try:
=SUMIF(B1:B300,"=" & DATE(2004,10,1), F1:F300) -SUMIF(B1:B300,"=" &
DATE(2004,11,1), F1:F300)

"LOU" wrote:

Hello!

how do I write this one?

B1 thru B300 has date values
F1 thru F300 has the dollar values

I need a formula to sum them up by date range using the between or
<..
SUMIF(B1:B300,"BETWEEN 10/01/2004 AND 11/01/2004", F1:F300) ?????
SUMPRODUCT..?
HELP.
Thank you.

All times are GMT +1. The time now is 11:06 AM.