Forum Discussion
Solved
Multiple data entry from drop down list
Hi all, I’m trying to create a diet tracker that allows me to be able to match a number to a specific meal and the calories etc attached to that meal. The general idea is a list of meals numbered ...
=SUM(MMULT(TRANSPOSE(N($B$4:$B$13=$I4:$M4)),E$4:E$13))
You can apply this formula. The formula is in cell O4 and filled across range O4:Q13. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.
=SUM(MMULT(TRANSPOSE(N($B$4:$B$13=$I4:$M4)),E$4:E$13))
You can apply this formula. The formula is in cell O4 and filled across range O4:Q13. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.
Youre a wizard! Thank-you!!