Excel Formula and function

New Contributor

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

2 Replies
Best Response confirmed by jmc3207 (New Contributor)

@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.

Screenshot 2021-02-09 at 07.37.36.png

@Riny_van_Eekelen Thankyou