Did you read the help on SUMIF?

What's the part that you don't understand and what simple worksheet
tests did you make to see if you could figure it out?

(No offense intended, but I'm shooting for you to have a learning
experience here - if you just want me to give you the answer, you're out
of luck.)


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111550