ExcelBanter - HOW DO YOU SUMIF THE NUMBER IS GREATER THAN BUT LESS THAN A #

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - HOW DO YOU SUMIF THE NUMBER IS GREATER THAN BUT LESS THAN A # (https://www.excelbanter.com/excel-worksheet-functions/49026-how-do-you-sumif-number-greater-than-but-less-than.html)

uma

HOW DO YOU SUMIF THE NUMBER IS GREATER THAN BUT LESS THAN A #

Bernie Deitrick

=SUMIF(range,"3")-SUMIF(range,"5")

--
HTH,
Bernie
MS Excel MVP

"uma" wrote in message
...

All times are GMT +1. The time now is 06:37 AM.