Sum figures if they are greater than and less than certain criteria

Hi,
i'm new to the forum and I am trying to sum the data in a column if it meets certain criteria. the 1st one is anything =>£0 and <£20.01, then i want to sum everything =>20.01 and <£40.00 and so on.
I'm sure this should be easy, but I can't figure it out, can any one help....

Thanks

=SUMIF(A1:A100,">=0")-SUMIF(A1:A100,">20.00")

sums from 0 to 20... adjust as necessary for other ranges.

in XL2007.

=SUMIFS(A1:A100,">=0",A1:A100,"<20.01")

if your ranges are stored in cells, then you can adjust formula to:

=SUMIF($A$1:$A$100,">="&X1)-SUMIF($A$1:$A$100,">"&Y1)

where X1 and Y1 contain your lower and upper bounds.. then you can copy formula down...

That would be a SUMPRODUCT() construct:

=SUMPRODUCT(--($A$1:$A$100>0), --($A$1:$A$100<=20), $A$1:$A$100)

=SUMPRODUCT(--($A$1:$A$100>20), --($A$1:$A$100<=40), $A$1:$A$100)