A
Adam
Hi All,
I'm using Excel 97 and am experience the below problem.
I have a list of retailers on row N and in row R I have the below
formula:
=SUMIF('TOTAL DATA'!$G$4:$G$60000,N12,'TOTAL DATA'!$X$4:$X$60000)
When this looks on retailer "003" this is returning 3 however when I go
into the worksheet called 'TOTAL DATA' and then select the retailer
"003" it gives me 0. I really don't know where this formula is getting
3 from. When you filter the list and select the column to do sum in the
taskbar it still gives me 0.
Both lookup fields are formatted as text so I cannot see this as a
formatting issue.
Please advise !
Adam
I'm using Excel 97 and am experience the below problem.
I have a list of retailers on row N and in row R I have the below
formula:
=SUMIF('TOTAL DATA'!$G$4:$G$60000,N12,'TOTAL DATA'!$X$4:$X$60000)
When this looks on retailer "003" this is returning 3 however when I go
into the worksheet called 'TOTAL DATA' and then select the retailer
"003" it gives me 0. I really don't know where this formula is getting
3 from. When you filter the list and select the column to do sum in the
taskbar it still gives me 0.
Both lookup fields are formatted as text so I cannot see this as a
formatting issue.
Please advise !
Adam