SOLVED

Excel Formula and function

Copper 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 (Copper Contributor)
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.

Screenshot 2021-02-09 at 07.37.36.png

@Riny_van_Eekelen Thankyou

1 best response

Accepted Solutions
best response confirmed by jmc3207 (Copper Contributor)
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.

Screenshot 2021-02-09 at 07.37.36.png

View solution in original post