Sum if Formula

  • Thread starter Thread starter BarryNeaves
  • Start date Start date
B

BarryNeaves

I am trying to write a formula.

I have a range of cells that I would like to add up if another cel
falls between the range.

=SUMIF($L$16:$L$12125,"<=0",DAT8)

This formula works.

for the second line, I wish to have the same sum if but have >=0 and/o
<=30

the DAT8 is a range of cells I wish to add up.

Can anyone offer me any advise?

Thanks.

Ba
 
BarryNeaves > said:
I am trying to write a formula.

I have a range of cells that I would like to add up if another cell
falls between the range.

=SUMIF($L$16:$L$12125,"<=0",DAT8)

This formula works.

for the second line, I wish to have the same sum if but have >=0 and/or
<=30

the DAT8 is a range of cells I wish to add up.

Can anyone offer me any advise?

Thanks.

Baz
Click to expand...

=SUMPRODUCT(($L$16:$L$12125>=0)*($L$16:$L$12125<=30)*DAT8)
 
You could try:

=SUMIF($L$16:$L$12125,">=0",Dat8)-SUMIF($L$16:$L$12125,">30",Dat8)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I am trying to write a formula.

I have a range of cells that I would like to add up if another cell
falls between the range.

=SUMIF($L$16:$L$12125,"<=0",DAT8)

This formula works.

for the second line, I wish to have the same sum if but have >=0 and/or
<=30

the DAT8 is a range of cells I wish to add up.

Can anyone offer me any advise?

Thanks.

Baz
 
Thanks for the help so far, although neither seems to return the correct
answers.

I also need the formula to seperate out the following:
0-30 Days
31-60 Days
61-90 Days
91-120 Days
121-150 Days
151-180 Days
181-270 Days
271-365 Days
365-99999 Days

I have a formula to calculate the days outstanding, I just need to
sumif the groups, but unsuccessfully.

Any thoughts?

Thanks.
 
I'd guess that the size (number of cells) of Dat8 isn't the same as L16
:L12125 !
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

Thanks for the help so far, although neither seems to return the correct
answers.

I also need the formula to seperate out the following:
0-30 Days
31-60 Days
61-90 Days
91-120 Days
121-150 Days
151-180 Days
181-270 Days
271-365 Days
365-99999 Days

I have a formula to calculate the days outstanding, I just need to
sumif the groups, but unsuccessfully.

Any thoughts?

Thanks.
 
Back
Top