I put area 1; area 2; area3; area4 and area5 respectively for for crop 1, crop2, crop3, crop4 and crop5.
My wish is to calculate a total of area despite the number of crop choose. .
when I choose less than 5 crop (by exemple: crop1 and crop2), to comput the total of area of the 2 crop, it is problem, error message appear.
I need help please.
Could you mind share with the community the xlsform that you have tried so far so that someone could figure a way-out for you.
Have a great day!