logvolume.png
I have attatched an example spreadsheet to explain what I'm trying to do.

I am trying to calculate different totals of volume depending on the diameter number

I want a sum of all of the volumes that have a diameter between 40 and 70 in one cell and 35 to 40 in another cell and then 20-35 in another.

How can I do this? I have tried several sumif functions but they dont seem to be working with multiple requirements .

Hope I have explained this properly!

Any help would be much appreciated.

Cheers,

Tom