Thanks! I don't know why, but my Excel did this, but the formula only worked
when I had the data on the same spreadsheet as the formula. I have 2003
Excel, but it works, so I am happy.

"David Biddulph" wrote:

=-TRUE gives -1, =--TRUE gives 1
=-FALSE gives 0, =--FALSE gives 0
1 and 0 are what you want to multiply by in your SUMPRODUCT.
--
David Biddulph

"Lindsey" wrote in message
...
What does -- mean?

"Eduardo" wrote:

Hi Lindsey
Assuming that the CPP, MSP and 8 are in the columns as described

=SUMPRODUCT(--(A:A=8),--(B:B="CPP"),--(C:C="MSP"),D:D)

If you are not using excel 2007 do

=SUMPRODUCT(--(A1:A100=8),--(B1:B100="CPP"),--(C1:C100="MSP"),D1:D100)

"Lindsey" wrote:

Example

A B C D
2 CPP JNY $4
4 GHY MSP $2
2 PWQ NOL $8
8 CPP MSP $9

I want it to sum if there is an 8 in column A, CPP in column B, and MSP
in
column C. The sum needs to come out of column D. Please let me know if
you
need anything else, thanks!

"Lindsey" wrote:

Sorry, the CPP, TSF, HDJ are all in different columns. Let me know if
you
still need an example, thanks!

"Eduardo" wrote:

Hi,
I don't understand if you have the CPP word in one column you want
to
summarize another one, but that is not what your formula is saying,
if the
below doesn't work please send an example
try

=SUM(SUMIF($a$100:$f$100,{CPP, TSF, HDJ},$f$100))

"Lindsey" wrote:

I have a spreadsheet with multiple colums and I want to sum if
there is a
certain word in each column. I feel like this shold be fairly
easy, this is
the formula I have now. Thanks!

=sumif( $a$100:$f$100, and( CPP, TSF, HDJ), $f$100)