SUMIF with multiple criteria

[penri0_0]

My brain has gone into meltdown and i need help with a formula that wil
look up data in two columns and if the criteria is met in column A i
will sum the adjacent cells in column B

Column A has time elapsed from invoice date to payment received (in
number format, not date)
Column B has the value of said invoice

Using the criteria below i want a sum total of all invoices that wer
paid in each range. I can get it to do the sum for all invoices pai
under 30days easily, but all the ones i've tried that include >=30<6
etc fail.
0-30
31-60
31-90
91-120
121+

Where am i going wrong? I've done it before but i just can't recal
what i did...

any suggestions appreciated

 

[Bernard Liengme]

How about using a Pivot Table?
OR use the FREQUENCY function?
The bin would have number 30,60,90,120 and a blank value at the end for over
120.
best wishes

 

[Bondi]

Hi,

Maybe you can use sumproduct()

=SUMPRODUCT(--(A1:A10>30),--(A1:A10<61),B1:B10)

Regards,
Bondi

 

[penri0_0]

Thanks for both suggestions. Pivot table not right for this piece of
work but thanks anyway.

SumProduct did the job though! What are the dashes between parenthesis?
Without them the formula returned 0, but with them it worked. What do
they do?

 

[Bondi]

Hi,

They make the results in to numerals so the summing thingy can take
place.

Result without "--" would be TRUE, with "--" thingies would be 1

Regards,
Bondi

 

[penri0_0]

Thanks Bondi

Thats two things i've learned today - almost worth coming in the
office!