You're right - it works
Thanks for the help

"pdgaustintexas" wrote:


This formula works for me:

=SUMIF(G6:G48,"=8.01",E6:E48)-SUMIF(G6:G48,"11.99",E6:E48)

Column G contains the amounts you want to sum
Column E is the criteria

--

pdgaustintexas


--
pdgaustintexas
------------------------------------------------------------------------
pdgaustintexas's Profile: http://www.excelforum.com/member.php...o&userid=30600
View this thread: http://www.excelforum.com/showthread...hreadid=505443