Hi,
I have an excel sheet which uses a number ref to tally up the values associated with it, so i'll have on one sheet:
Item REF Price
banana's 1.1 £2.56
chips 4.5 £5.80
potatoes 2.7 £1.19
apples 1.10 £3.20
And on another "totals" sheet a sumif formula:
=SUMIF(sheet1!E7:E200,A1,sheet1!F7:F200) - Cell A1 has the value 1.1 in it
+SUMIF(sheet1!E7:E200,A2,sheet1!F7:F200) - Cell A2 has the value 1.2 in it
and so on till we get to
+SUMIF(sheet1!E7:E200,A10,sheet1!F7:F200) - Cell A2 has the value 1.10 in it
The problem is the formula cant distinguish between 1.1 and 1.10 - so it would return the value of £5.76 for 1.1 and 1.10 instead of £2.56 in 1.1 and £3.20 in 1.10.
Does anyone have a solution to this issue - I have tried changing the cell format to text/ number with 1 decimal point, general etc but it doesn't work??
Many thanks JD
Bookmarks