Add up a column based on values in other columns

  • Thread starter Thread starter Jay
  • Start date Start date
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
 
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
 
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
 
Now you want Sumproduct. Something like:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum Values from different column 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Hide columns based on row values 2
Find text in N columns and one Row 1
Excel Concatenate with line breaks but ignore blank cells 3
Conditional format a column based on value in a different column 3
How to add values in one column based on values in another column 6
Largest value in column A based on conditions in columns B and C 6

Back
Top