conditional sumif
 

I've seen similar threads here but can't seem to get them to work...here is
my situation.

spreadsheet 1
col A col B col C
FDP cpu 1
INS tape 2
FSI disk 3
FSI cpu 4
FSI disk 5

I need the answer to this question--If Col A = FSI AND Col B = disk, sum
column C. In this case, I expect 8 to be returned. I will be posting the
formula in spreadsheet 2, if that is important.

Please help!!

--
Thanks so much!

conditional sumif
 

=SUMPRODUCT((A1:A10="FSI")*(B1:B10="disk")*(C1:C10 ))

Regards

Trevor


"steph" wrote in message
...
I've seen similar threads here but can't seem to get them to work...here
is
my situation.

spreadsheet 1
col A col B col C
FDP cpu 1
INS tape 2
FSI disk 3
FSI cpu 4
FSI disk 5

I need the answer to this question--If Col A = FSI AND Col B = disk, sum
column C. In this case, I expect 8 to be returned. I will be posting the
formula in spreadsheet 2, if that is important.

Please help!!

--
Thanks so much!

conditional sumif
 

BINGO!!!! I would never have thought to use SUMPRODUCT because I don't see
this task as a multiplication task. But heck...it works. Thank you for the
quick reply and the easy solution.
--
Thanks so much!


"Trevor Shuttleworth" wrote:

=SUMPRODUCT((A1:A10="FSI")*(B1:B10="disk")*(C1:C10 ))

Regards

Trevor


"steph" wrote in message
...
I've seen similar threads here but can't seem to get them to work...here
is
my situation.

spreadsheet 1
col A col B col C
FDP cpu 1
INS tape 2
FSI disk 3
FSI cpu 4
FSI disk 5

I need the answer to this question--If Col A = FSI AND Col B = disk, sum
column C. In this case, I expect 8 to be returned. I will be posting the
formula in spreadsheet 2, if that is important.

Please help!!

--
Thanks so much!

conditional sumif
 

You're welcome ... glad to help


"steph" wrote in message
...
BINGO!!!! I would never have thought to use SUMPRODUCT because I don't
see
this task as a multiplication task. But heck...it works. Thank you for
the
quick reply and the easy solution.
--
Thanks so much!


"Trevor Shuttleworth" wrote:

=SUMPRODUCT((A1:A10="FSI")*(B1:B10="disk")*(C1:C10 ))

Regards

Trevor


"steph" wrote in message
...
I've seen similar threads here but can't seem to get them to
work...here
is
my situation.

spreadsheet 1
col A col B col C
FDP cpu 1
INS tape 2
FSI disk 3
FSI cpu 4
FSI disk 5

I need the answer to this question--If Col A = FSI AND Col B = disk,
sum
column C. In this case, I expect 8 to be returned. I will be posting
the
formula in spreadsheet 2, if that is important.

Please help!!

--
Thanks so much!

conditional sumif
 

I have never used this with the * sign howeverif you find that
"=SUMPRODUCT((A1:A10="FSI")*(B1:B10="disk")*(C1:C1 0))" does not work you can
try another combination of the sae i.e.

=SUMPRODUCT(--(A1:A10="FSI"),--(B1:B10="disk"),--(C1:C10))

this works fine, you can also substitute the "--" with 'SumProduct' each time

have fun!


"Trevor Shuttleworth" wrote:

=SUMPRODUCT((A1:A10="FSI")*(B1:B10="disk")*(C1:C10 ))

Regards

Trevor


"steph" wrote in message
...
I've seen similar threads here but can't seem to get them to work...here
is
my situation.

spreadsheet 1
col A col B col C
FDP cpu 1
INS tape 2
FSI disk 3
FSI cpu 4
FSI disk 5

I need the answer to this question--If Col A = FSI AND Col B = disk, sum
column C. In this case, I expect 8 to be returned. I will be posting the
formula in spreadsheet 2, if that is important.

Please help!!

--
Thanks so much!

conditional sumif
 

"Peter" wrote in message
...
I have never used this with the * sign howeverif you find that
"=SUMPRODUCT((A1:A10="FSI")*(B1:B10="disk")*(C1:C1 0))" does not work you
can
try another combination of the sae i.e.

=SUMPRODUCT(--(A1:A10="FSI"),--(B1:B10="disk"),--(C1:C10))

The * operator and the -- double unary behave in the same way (see
http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed
explanation), but in both cases the operator is not needed before the
straight array, only before the conditional tests

=SUMPRODUCT(--(A1:A10="FSI"),--(B1:B10="disk"),C1:C10)

this works fine, you can also substitute the "--" with 'SumProduct' each
time

This sounds very wrong to me, do you mean

=SUMPRODUCT(--(A1:A10="FSI"))+SUMPRODUCT(--(B1:B10="disk"))+SUMPRODUCT(--(C1
:C10))

because that is just meaningless to me, it gives a result, but nothing near
the correct result.