If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
sumif only seeing one row
Tried to find an answer but haven't found one yet.
I have two sheets. On Sheet 1, I have a Demo Code (1, 2, 3, etc.) in A9:A17 and a total quantity column in column W. This is where my sumif would go. On Sheet 2, I have the Demo Code going across from D5:L5. Below that, I have quantities listed for each demo code going to different people. The columns are then totaled below in row 113. I want to show the quantity for each demo code in the Total Quantity column on Sheet 1. In my total quantity column on Sheet 1, I have the following formula: =SUMIF('Sheet 2'!$D$5:$L$5,'Sheet 1'!$A9,'Sheet 2'!$D$6:$L$113). So for some reason, it's only returning the first row (D6) and not the entire column. The column does have spaces as each address is separated by a row or two, but since the range is listed, I don't know why that would be a problem. Any ideas? Thanks! |
Thread Tools | |
Display Modes | |
|
|