Yeah, straight-forward

=SUMPRODUCT(--(F2:F100="East Enterprise"),--(V2:v100<"CSI"),G2:G100)

for the low-down on --, take a look at
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"PokerZan" wrote in
message ...

And the questions never stop... :P

There are about 7 different options that could be in column V, I am
only looking to extract "CSI", the others I want to add up the other 6
options...

So is there an way to add up all that DON'T say "CSI" in column V?

Thanks,
PZan


--
PokerZan
------------------------------------------------------------------------
PokerZan's Profile:
http://www.excelforum.com/member.php...o&userid=23480
View this thread: http://www.excelforum.com/showthread...hreadid=392980