Sumproduct?

[teeb]

I'm trying to get the sum of a range in columb A, only if in the same
row in columb b has "text b" AND columb c has "text c"

Any help will be appreciated!

 

[RagDyeR]

Try this:

=SUMPRODUCT((B1:B100="textb")*(C1:C100="textc")*A1:A100)

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


I'm trying to get the sum of a range in columb A, only if in the same
row in columb b has "text b" AND columb c has "text c"

Any help will be appreciated!

 

[Don Guillett]

easy enough
=sumproduct((b3:b33="b")*(c3:c33="c")*a3:a33)
note the ranges MUST be the same size.

 

[Guest]

=SUMPRODUCT(A1:10,--(B1:B10="text b"),--(C1:C10="text c"))

should work.

 

[RagDyeR]

Well I'll be darned !

A *triple* dead-heat.<bg>

--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------


I'm trying to get the sum of a range in columb A, only if in the same
row in columb b has "text b" AND columb c has "text c"

Any help will be appreciated!

 

[Don Guillett]

Didn't notice that they were all the same. I, also, have never seen that
before.

 

[L. Howard Kittle]

Man...! What are the odds of that???
Must be about the same as Lou Ghehrig dying of Lou Gehrig disease!!!
<vbg>