SUMIF

Dukester · May 25th, 2002, 03:57 PM

This should be simple. I am trying to only certain numbers in a row if they correlate with a range of dates in the row above them. I have tried the following formulas:

1. =IF(AND(D5:R5>=A44,D5:R5
2. =SUMIF(D5:R5,">=A44,
SOMEONE PLEASE HELP!

[ This Message was edited by: Dukester on 2002-05-25 15:03 ]

Aladin Akyurek · May 25th, 2002, 04:05 PM

Quote:

On 2002-05-25 14:57, Dukester wrote:
This should be simple. I am trying to only certain numbers in a row if they correlate with a range of dates in the row above them. I have tried the following formulas:

1. =IF(AND(D5:R5>=A44,D5:R5
2. =SUMIF(D5:R5,">=A44,
SOMEONE PLEASE HELP!

Try:

=SUMIF(D5:R5,">="&A44,D6:R6)-SUMIF(D5:R5,">"&A45,D6:R6)

[ This Message was edited by: Aladin Akyurek on 2002-05-25 15:08 ]

Dukester · May 25th, 2002, 04:11 PM

I believe some of your formula was cut off. mine was too until I disabled the HTML, BBcode, and Smilies (I edited it). Please try again. I would greatly appreciate it.

Aladin Akyurek · May 25th, 2002, 04:15 PM

Quote:

On 2002-05-25 15:11, Dukester wrote:
I believe some of your formula was cut off. mine was too until I disabled the HTML, BBcode, and Smilies (I edited it). Please try again. I would greatly appreciate it.

This is the whole formula, consisting of 2 SUMIFs:

=SUMIF(D5:R5,">="&A44,D6:R6)-SUMIF(D5:R5,">"&A45,D6:R6)

Dukester · May 25th, 2002, 04:21 PM

The following formula provided me a date, not a sum of numbers:
=SUMIF(D5:R5,">="&A44,D6:R6)-SUMIF(D5:R5,"<"&A45,D6:R6)

Aladin Akyurek · May 25th, 2002, 04:27 PM

Quote:

On 2002-05-25 15:21, Dukester wrote:
The following formula provided me a date, not a sum of numbers:
=SUMIF(D5:R5,">="&A44,D6:R6)-SUMIF(D5:R5,"<"&A45,D6:R6)

If D5:R5 holds dates (which I assumed) and D6:R6 just numbers (which conditionally must be summed up), I'd suggest formatting the formula cell as General.

Dukester · May 25th, 2002, 04:58 PM

I got your formula to work with a minor modification, but it gives me a date rather than a number for some reason. When I manually change the cell format to "number" it then gives me the proper calculation. Do you know why?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 25th, 2002, 03:57 PM	#1
Dukester New Member Join Date: May 2002 Posts: 8	This should be simple. I am trying to only certain numbers in a row if they correlate with a range of dates in the row above them. I have tried the following formulas: 1. =IF(AND(D5:R5>=A44,D5:R5 2. =SUMIF(D5:R5,">=A44, SOMEONE PLEASE HELP! [ This Message was edited by: Dukester on 2002-05-25 15:03 ]

May 25th, 2002, 04:11 PM	#3
Dukester New Member Join Date: May 2002 Posts: 8	I believe some of your formula was cut off. mine was too until I disabled the HTML, BBcode, and Smilies (I edited it). Please try again. I would greatly appreciate it.

May 25th, 2002, 04:21 PM	#5
Dukester New Member Join Date: May 2002 Posts: 8	The following formula provided me a date, not a sum of numbers: =SUMIF(D5:R5,">="&A44,D6:R6)-SUMIF(D5:R5,"<"&A45,D6:R6)

May 25th, 2002, 04:58 PM	#7
Dukester New Member Join Date: May 2002 Posts: 8	I got your formula to work with a minor modification, but it gives me a date rather than a number for some reason. When I manually change the cell format to "number" it then gives me the proper calculation. Do you know why?