I am looking for a formula similar to sumif that can add values based on a previous cell's value being yes. I'm working on an order form where there are multiple columns and you can select yes for all options you are interested in. I want a formula to then calculate the total price by adding the price listed to next to each cell with a yes in it. Is this possible?
Example:
Person Bananas $ Apples Carrots Spinach
ABC Yes $2.50 Yes $1 Total would be $3.50
Welcome to the forum!
My guess is that it can be done with either a two dimensional SUMIF [=SUMIF(A1:D5,"yes",B1:E5)], a creatively structured SUMIFS, or a chain of SUMIF + SUMIF + SUMIF + Etc., but it's hard to tell without knowing what form of non-concurrency is causing your headache. It would help immensely if you could attach a sample workbook - canned instructions below:
Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
If your problem has been solved, please use "Thread Tools" to mark the thread as "Solved".
If you're grateful for this site's existence and would like to contribute to the community, please consider posting something hilarious in our joke thread:
https://www.excelforum.com/the-water...ke-thread.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks