| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup not working
I'm having issues witha spreadsheet. In one sheet called data, account
numbers are in Column B and Values (£) in column D. On my 'Calc' sheet this data is pulled across using the =Data!B14 (etc) formula into columns replicating that in data. What i am trying to achieve is that I have a a few account numbers that I'd like to find and total up the sum of their values. These are in column G. There are numerous amounts of identical account numbers but with different values, which I need subtotaling. I have sorted these so they are in ascending order. The formula I have been using is =SUM(($B$1:$B$750=G4)*($D$1:$D$750)) All i am gettign is zeroes. Can anyone help? I think the problem may be in that its looking at a formula rather than text or number, I've tried a simple vlookup and that doesn't work either. Thanks in advance! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vlookup not working
Maybe this =SUMPRODUCT(($B$1:$B$750=G4)*($D$1:$D$750)) Mike "JonOxford" wrote: I'm having issues witha spreadsheet. In one sheet called data, account numbers are in Column B and Values (£) in column D. On my 'Calc' sheet this data is pulled across using the =Data!B14 (etc) formula into columns replicating that in data. What i am trying to achieve is that I have a a few account numbers that I'd like to find and total up the sum of their values. These are in column G. There are numerous amounts of identical account numbers but with different values, which I need subtotaling. I have sorted these so they are in ascending order. The formula I have been using is =SUM(($B$1:$B$750=G4)*($D$1:$D$750)) All i am gettign is zeroes. Can anyone help? I think the problem may be in that its looking at a formula rather than text or number, I've tried a simple vlookup and that doesn't work either. Thanks in advance! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vlookup not working
This used to be online:
http://www.savefile.com/files/2166898 I copied the file to Word. Haven't seen the link up in a while... HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Mike H" wrote: Maybe this =SUMPRODUCT(($B$1:$B$750=G4)*($D$1:$D$750)) Mike "JonOxford" wrote: I'm having issues witha spreadsheet. In one sheet called data, account numbers are in Column B and Values (£) in column D. On my 'Calc' sheet this data is pulled across using the =Data!B14 (etc) formula into columns replicating that in data. What i am trying to achieve is that I have a a few account numbers that I'd like to find and total up the sum of their values. These are in column G. There are numerous amounts of identical account numbers but with different values, which I need subtotaling. I have sorted these so they are in ascending order. The formula I have been using is =SUM(($B$1:$B$750=G4)*($D$1:$D$750)) All i am gettign is zeroes. Can anyone help? I think the problem may be in that its looking at a formula rather than text or number, I've tried a simple vlookup and that doesn't work either. Thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
| vlookup not working | Excel Worksheet Functions | |||
| Vlookup not working for me. | Excel Worksheet Functions | |||
| Vlookup not working | Excel Worksheet Functions | |||
| Vlookup no working | New Users to Excel | |||
Linear Mode
