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
|