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!

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!

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!