Hi All,

Have a problem working a formula for the following:

A B C
1 mar ra123 10
2 mar so123 100
3 apr ra234 20

I need to say, if A1 to A3 is equal to mar and B1 to B32 is equal to
non-blank or 0 then add what's in C corresponding to where mar is found.

I used following:
if(a1:a3=mar,"sumif(b1:b3,"0",c1:c3))

This did not work so can someone please help me, very much appreciated.

Hi,

Try something like this

=SUMPRODUCT(--(A1:A3="mar"),--(B1:B30),C1:C3)


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Corca" wrote:

Hi All,

Have a problem working a formula for the following:

A B C
1 mar ra123 10
2 mar so123 100
3 apr ra234 20

I need to say, if A1 to A3 is equal to mar and B1 to B32 is equal to
non-blank or 0 then add what's in C corresponding to where mar is found.

I used following:
if(a1:a3=mar,"sumif(b1:b3,"0",c1:c3))

This did not work so can someone please help me, very much appreciated.

Hi,

I tried it did not work.

My problem better explained directly below.

A B C
1 mar ra123 10
2 mar so123 100
3 mar 20
4 apr ra234 50


I'll try and play around with sumproduct a bit more.

I may endup adding in extra colunms to breakup data and then do what i need.

If anyone else can get a formula to work please help. Thanks.







"Shane Devenshire" wrote:

Hi,

Try something like this

=SUMPRODUCT(--(A1:A3="mar"),--(B1:B30),C1:C3)


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Corca" wrote:

Hi All,

Have a problem working a formula for the following:

A B C
1 mar ra123 10
2 mar so123 100
3 apr ra234 20

I need to say, if A1 to A3 is equal to mar and B1 to B32 is equal to
non-blank or 0 then add what's in C corresponding to where mar is found.

I used following:
if(a1:a3=mar,"sumif(b1:b3,"0",c1:c3))

This did not work so can someone please help me, very much appreciated.

=SUMPRODUCT(C1:C3,--(A1:A3="mar"),--(B1:B3<""))

If this post helps click Yes
---------------
Jacob Skaria


"Corca" wrote:

Hi,

I tried it did not work.

My problem better explained directly below.

A B C
1 mar ra123 10
2 mar so123 100
3 mar 20
4 apr ra234 50


I'll try and play around with sumproduct a bit more.

I may endup adding in extra colunms to breakup data and then do what i need.

If anyone else can get a formula to work please help. Thanks.







"Shane Devenshire" wrote:

Hi,

Try something like this

=SUMPRODUCT(--(A1:A3="mar"),--(B1:B30),C1:C3)


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Corca" wrote:

Hi All,

Have a problem working a formula for the following:

A B C
1 mar ra123 10
2 mar so123 100
3 apr ra234 20

I need to say, if A1 to A3 is equal to mar and B1 to B32 is equal to
non-blank or 0 then add what's in C corresponding to where mar is found.

I used following:
if(a1:a3=mar,"sumif(b1:b3,"0",c1:c3))

This did not work so can someone please help me, very much appreciated.

Hi Jacob

Thanks it worked.

Thanks to both Shane a Jacob, very much appreciated.

Great help.

thanks,

Corca.


"Corca" wrote:

Hi All,

Have a problem working a formula for the following:

A B C
1 mar ra123 10
2 mar so123 100
3 apr ra234 20

I need to say, if A1 to A3 is equal to mar and B1 to B32 is equal to
non-blank or 0 then add what's in C corresponding to where mar is found.

I used following:
if(a1:a3=mar,"sumif(b1:b3,"0",c1:c3))

This did not work so can someone please help me, very much appreciated.

=SUMPRODUCT(--(A1:A4="mar"),--(B1:B4<""),C1:C4)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Corca" wrote in message
...
Hi,

I tried it did not work.

My problem better explained directly below.

A B C
1 mar ra123 10
2 mar so123 100
3 mar 20
4 apr ra234 50


I'll try and play around with sumproduct a bit more.

I may endup adding in extra colunms to breakup data and then do what i
need.

If anyone else can get a formula to work please help. Thanks.







"Shane Devenshire" wrote:

Hi,

Try something like this

=SUMPRODUCT(--(A1:A3="mar"),--(B1:B30),C1:C3)


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Corca" wrote:

Hi All,

Have a problem working a formula for the following:

A B C
1 mar ra123 10
2 mar so123 100
3 apr ra234 20

I need to say, if A1 to A3 is equal to mar and B1 to B32 is equal to
non-blank or 0 then add what's in C corresponding to where mar is
found.

I used following:
if(a1:a3=mar,"sumif(b1:b3,"0",c1:c3))

This did not work so can someone please help me, very much appreciated.

__________ Information from ESET Smart Security, version of virus
signature database 3832 (20090206) __________

The message was checked by ESET Smart Security.

http://www.eset.com






__________ Information from ESET Smart Security, version of virus signature database 3832 (20090206) __________

The message was checked by ESET Smart Security.

http://www.eset.com