Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF Criteria | Excel Discussion (Misc queries) | |||
SumIF | Excel Discussion (Misc queries) | |||
SUMIF with only one criteria cell within range | Excel Discussion (Misc queries) | |||
creiteria in sumif | New Users to Excel | |||
sumif 2 criteria | Excel Worksheet Functions |