SUMIF discontinuous cells
Attachment 613688
I want W6 formula to return SUM of MTL QTY values IF row 2 denotes "Notice to Proceed" in the paired columns........my current formula of =SUMIF([E2, G2, I2, K2, M2, O2, Q2, S2, U2], "Notice to Proceed", [E6,G6,I6,K6,M6,O6,Q6,S6,U6]) is not working. I tried both merging and unmerging my row 2 cells. I assumed the problem was discontinuous ranges for criteria and sum? Please help!
A couple of things:
1. Things usually go better with a sample workbook. Responders don't have to set up the the data and possibly get it wrong.
2. What is it you are trying to do? I've tried reverse engineering the formula but aside from improper syntax for SUMIF, I can't discern what you want. Do you want to take action if the sum of those cells is a certain value?
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.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
As you are merging pairs of cells E & F, G & H etc. then the text "Notice to Proceed" will only be present in cells E2, G2 etc., so you could treat the ranges as contiguous, i.e. use this formula in cell W6:
=SUMIF(E$2:V$2,"Notice to Proceed",E6:V6)
Copy down as required.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks