Feb 08 2021 10:17 PM
hi I have worksheet below and I would like to do a summary sheet that tell me how many tonnes and Ha according to cropping type and variety Can someone please helps I tried sumif but too many criteria but when I tried sumifs it says I don't have enough criteria am a little lost Thanks in advanced
Feb 08 2021 10:38 PM
Solution@jmc3207 You can use a pivot table for this. Couldn't work in the file you uploaded. Copied the data to a new workbook and created a pivot table there. See attached.
Feb 08 2021 10:38 PM
Solution@jmc3207 You can use a pivot table for this. Couldn't work in the file you uploaded. Copied the data to a new workbook and created a pivot table there. See attached.