Sum Query

[pookietherabbit]

Sorry if this is an obvious question.

In column 'A' I have a list of some 1000+ values.

I would like to be able to add all of the cells in this column that are between certain values.

So if D1 was £1101 and D2 was £3400, how can I add all of the values in Column A together that are between these figures?

 

[hatman]

Welcome to the board!

One option would be

=sumproduct(--(A1:A1000>D1),--(A1:A1000<D2),A1:A1000)

 

[Peter_SSs]

pookietherabbit

Welcome to the Mr Excel board!

Try this if you want to include D1 & D2 values in the sum:
=SUMIF(A:A,">="&D1)-SUMIF(A:A,">"&D2)

Or this if you want to exclude D1 & D2 values from the sum:
=SUMIF(A:A,">"&D1)-SUMIF(A:A,">="&D2)

 

[pookietherabbit]

Sorry for the delay in responding.

Thanks for your help,