Add up a column based on values in other columns
 

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

Add up a column based on values in other columns
 

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

Add up a column based on values in other columns
 

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

Add up a column based on values in other columns
 

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

Add up a column based on values in other columns
 

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

Add up a column based on values in other columns
 

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