needs help with excel. i need to write a formula to check
3 columns and then sum the 4th column if ther value of the
3 columns are true.

Hi
try
=SUMPRODUCT(--(A1:A100="cond1"),--B1:B100="cond2"),--
(C1:C100="cond3"),D1:D100)

-----Original Message-----
needs help with excel. i need to write a formula to check
3 columns and then sum the 4th column if ther value of
the
3 columns are true.
.

I have done the
exercise:=SUMPRODUCT(--(A1:A=H1),--(B:B=426351),--(C:C=cr),D:D)

and I get #NAME?

Please advise.

Thanks!!!!!!


Daniel



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

I have tried: =SUMPRODUCT(--(A1:A=H1),--(B:B=426351),--
(C:C=cr),D:D)

and I get error:#NAME?

-----Original Message-----
Hi
try
=SUMPRODUCT(--(A1:A100="cond1"),--B1:B100="cond2"),--
(C1:C100="cond3"),D1:D100)

-----Original Message-----
needs help with excel. i need to write a formula to
check
3 columns and then sum the 4th column if ther value of
the
3 columns are true.
.

.

Daniel
Please note in the initial sample formula Frank and myself provided,
crtierias where between apostrophees.
In your case, assuming values in Column A and Column C are text, amend with
:
=SUMPRODUCT(--(A1:A="00001001"),--(B:B=426351),--(C:C="cr"),D:D)

HTH
Cordially
Pascal

"Daniel Macgaw" a écrit dans le message de
...
I have tried: =SUMPRODUCT(--(A1:A=H1),--(B:B=426351),--
(C:C=cr),D:D)

and I get error:#NAME?

-----Original Message-----
Hi
try
=SUMPRODUCT(--(A1:A100="cond1"),--B1:B100="cond2"),--
(C1:C100="cond3"),D1:D100)

-----Original Message-----
needs help with excel. i need to write a formula to
check
3 columns and then sum the 4th column if ther value of
the
3 columns are true.
.

.

Hi
couple of things :-)
- SUMPRODUCT does not accept ranges like A:A. You have to
use something like A1:A1000
- You have to use apostrophes to look for strings.

So assuming that cell H1 contains the condition for column
A try:
=SUMPRODUCT(--(A1:A1000=H1),--(B1:B1000=426351),--
(C1:C1000="cr"),D1:D1000)

If the values in column B are stroed as 'Text' you may use:
=SUMPRODUCT(--(A1:A1000=H1),--(B1:B1000="426351"),--
(C1:C1000="cr"),D1:D1000)

-----Original Message-----
I have tried: =SUMPRODUCT(--(A1:A=H1),--(B:B=426351),--
(C:C=cr),D:D)

and I get error:#NAME?

-----Original Message-----
Hi
try
=SUMPRODUCT(--(A1:A100="cond1"),--B1:B100="cond2"),--
(C1:C100="cond3"),D1:D100)

-----Original Message-----
needs help with excel. i need to write a formula to
check
3 columns and then sum the 4th column if ther value of
the
3 columns are true.
.

.

.