Hello All,
This should be a simple formula, however I am having trouble with it (please see attached). What I am trying to get at is how do you put together a formula that - If column K on the spreadsheet, (Contr_Org), is = "U" then take the (Sales_Volume) - column H, and sum up the volume of that criteria, if not then dont add it.
Please help.
Thanks,
Hendrix P.
This should work
=SUMIF(K2:K8,"U",H2:H8)
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hello AlKey,
That didnt work. I think the formula should be something like =If(K2=U,H2),0 this is the wrong forumla but i am trying to express something similar. Meaning if the Cont_Orig = "U" then give me the Sales Volume, if not then its 0
SUMIF will return 0 if "U" is not present and otherwise will SUM H column based on criteria. You should've tried it first.
Yes I got it thank you very much!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks