SUMIF across sheets and row/columns

[cosmopolicious]

Hi,

Beginner Excel user here....
I have a summary sheet that I'd like to use to show me how many items have been sold in each Farm for a specific time frame.
I understand that SUMIF won't work because my range is a column but my sum_range is a row. The criteria has to be Item Code (Column A). I can't figure out the work-around. I've read up on SUMPRODUCT and TRANSPOSE but keep getting errors.

I've added sample data below.
Results should show:
Apples = 4
Cherry = 2
etc.

Appreciate your help! Thanks in advance.

Summary Sheet

	A	B	C	D
1	Item Code	Item Name	Day 1-3	Day 4-6
2	100	Apple
3	101	Cherry
4	102	Orange
5	103	Kiwi
6	104	Pear
7	105	Strawberry
8	106	Melon
9	107	Grape

<tbody>
</tbody>

Farm 1

	A	B	C	D	E	F	G	H
1	Item Code	Item Name	Day 1	Day 2	Day 3	Day 4	Day 5	Day 6
2	100	Apple	1	2	1	0	1	0
3	101	Cherry	0	1	1	1	1	1
4	102	Orange	2	1	4	1	0	4
5	103	Kiwi	0	0	0	0	0	0
6	104	Pear	1	2	0	4	0	0
7	105	Strawberry	0	1	1	0	4	2
8	106	Melon	1	0	0	0	1	0
9	107	Grape	0	0	0	1	1	1

<tbody>
</tbody>

Farm 2, 3, 4 etc would be on different sheets with the same items but different quantities.

 

[oldbrewer]

maybe do the sums on each sheet then pull those values to a helper sheet, do the sums and pull the answers to your main summary sheet ?

 

[cosmopolicious]

maybe do the sums on each sheet then pull those values to a helper sheet, do the sums and pull the answers to your main summary sheet ?

Hmm... That works, but I'm still hoping for a more elegant solution as I want to avoid having to add sums for each date range on each sheet (I have 20 different "farm" sheets and 365 days worth of sales data, that I'm dividing into weeks actually).

 

[oldbrewer]

so put ALL your data on one sheet each row would be farm number, item code, fruit, date, amount and analyse that using either sumproduct or a pivot table...