SUMIF Criteria met

Ron Erdeljac

I'm trying to calculate the sum of the numbers in a cell when the cell meets a criteria range. This formula works fine for providing the number in cell that is greater than 30. But what if I want the sum to be the total of the numbers in the cells that are equal to or greater than 25 and less than 30? =SUMIF(AlbumCt15:AlbumCt171,>30)

John Jonassen

Try

=SUMIFS(AlbumCt15:AlbumCt171,AlbumCt15:AlbumCt171,>=25,AlbumCt15:AlbumCt171,<=30)

John Jonassen

Try

=SUMIFS(AlbumCt15:AlbumCt171,AlbumCt15:AlbumCt171,>=25,AlbumCt15:AlbumCt171,<=30)

Ron Erdeljac

Yes, thank you for the prompt response!

John Jonassen

That's great, @Ron!!! And you're welcome!