I have an Excel sheet where there are three columns A, B, C and around
50 rows. I need to add up the values in column C only if the
corresponding cell value in column B is "mytext". Is there a function
in Excel which can do this?

Thanks,
Jayasimhan

sumif(b1:b50,"mytext",c1:c50)

Jay wrote:
I have an Excel sheet where there are three columns A, B, C and around
50 rows. I need to add up the values in column C only if the
corresponding cell value in column B is "mytext". Is there a function
in Excel which can do this?

Thanks,
Jayasimhan

The function is Sumif. There's a good explanation in Help.

--
Regards,
Fred


"Jay" wrote in message
oups.com...
I have an Excel sheet where there are three columns A, B, C and around
50 rows. I need to add up the values in column C only if the
corresponding cell value in column B is "mytext". Is there a function
in Excel which can do this?

Thanks,
Jayasimhan

On Feb 15, 6:58 pm, "Fred Smith" wrote:
The function is Sumif. There's a good explanation in Help.

--
Regards,
Fred

"Jay" wrote in message

oups.com...

I have an Excel sheet where there are three columns A, B, C and around
50 rows. I need to add up the values in column C only if the
corresponding cell value in column B is "mytext". Is there a function
in Excel which can do this?

Thanks,
Jayasimhan

Thanks guys. But my problem is a lil more complicated. I need to check
multiple columns(say A, B and D) before summing up the column C. How
can I achieve this.

thanks,
Jay

Please don't treat us like mushrooms, Jay.....

Post ALL of the rules and maybe some sample data, so we'll know what your
actual situation is.

***********
Regards,
Ron

XL2002, WinXP


"Jay" wrote:

On Feb 15, 6:58 pm, "Fred Smith" wrote:
The function is Sumif. There's a good explanation in Help.

--
Regards,
Fred

"Jay" wrote in message

oups.com...

I have an Excel sheet where there are three columns A, B, C and around
50 rows. I need to add up the values in column C only if the
corresponding cell value in column B is "mytext". Is there a function
in Excel which can do this?

Thanks,
Jayasimhan

Thanks guys. But my problem is a lil more complicated. I need to check
multiple columns(say A, B and D) before summing up the column C. How
can I achieve this.

thanks,
Jay

Now you want Sumproduct. Something like:

=sumproduct((a1:a150="myatext")*(b1:b50="mybtext") *(d1:d50="mydtext")*(c1:c50))

--
Regards,
Fred


"Ron Coderre" wrote in message
...
Please don't treat us like mushrooms, Jay.....

Post ALL of the rules and maybe some sample data, so we'll know what your
actual situation is.

***********
Regards,
Ron

XL2002, WinXP


"Jay" wrote:

On Feb 15, 6:58 pm, "Fred Smith" wrote:
The function is Sumif. There's a good explanation in Help.

--
Regards,
Fred

"Jay" wrote in message

oups.com...

I have an Excel sheet where there are three columns A, B, C and around
50 rows. I need to add up the values in column C only if the
corresponding cell value in column B is "mytext". Is there a function
in Excel which can do this?

Thanks,
Jayasimhan

Thanks guys. But my problem is a lil more complicated. I need to check
multiple columns(say A, B and D) before summing up the column C. How
can I achieve this.

thanks,
Jay