Hello all,
I've created a spreadsheet for counting food macros using vlookup. Is there any way to use the auto sum function for cells that have the vlookup formula in them but hasn't had any information selected? the auto sum only works when all cells are filled from the drop down list. Otherwise, it shows #N/A.
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I've created a spreadsheet for counting food macros using vlookup. Is there any way to use the auto sum function for cells that have the vlookup formula in them but hasn't had any information selected? the auto sum only works when all cells are filled from the drop down list. Otherwise, it shows #N/A.
Food Item | Calorie | ||
Monday | Pecans 28g | 200 | |
Almonds 56g | 340 | ||
Almonds 28g | 170 | ||
Pecans 28g | 200 | ||
Pecans 28g | 200 | ||
Almonds 56g | 340 | ||
Almond Milk Unsweetened 8oz/240ml | 30 | ||
Pecans 28g | 200 | ||
#N/A | |||
Pecans 28g | 200 | ||
<colgroup><col></colgroup><tbody> </tbody> | #N/A |
<colgroup><col><col><col></colgroup><tbody>
</tbody>