![]() |
#1
|
|||
|
|||
![]()
Kindly look at the table below.
Along A1, A2, A3,….., we have a list of fruits. Along B1, B2, B3,……, we have a list of the quantities of each item. Along C1, C2, C3,……, we have the corresponding calorific values of each fruit. Along the subsequent columns, we enter the number of a particular fruit eaten that day. ![]() How can I ensure that the total number of fruits entered does not exceed the total quantity available, i.e., since we have 3 oranges, all of which have been consumed by Tuesday, if I try to enter an orange on Wednesday it, either, prevents me from entering any value in that cell, or warns me. Also, how can I ensure that at the bottom, it automatically displays the sum of the calorific value of fruits consumed that day. |
#2
|
|||
|
|||
![]()
Maybe like the attached.
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Increase number in cell, based on value in adjacent cell | scottyb | Excel | 3 | 02-02-2017 03:51 AM |
![]() |
Marvinapplegate1964 | Excel | 1 | 05-04-2016 01:49 PM |
![]() |
wmedjaxnjr | Excel | 1 | 04-09-2016 04:22 PM |
![]() |
mkasem | Word VBA | 2 | 09-29-2013 08:36 PM |
Change formula cell range based on cell value | Scoth | Excel | 4 | 10-25-2012 07:51 AM |