Add up a column based on values in other columns

J

Jay

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
 
J

Jay

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

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
 
R

Ron Coderre

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
 
F

Fred Smith

Now you want Sumproduct. Something like:

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