SUMIF criteria - adding all months

Sorry for some reason, I am not able to attach the file..
But basically the format goes like below :

| A | B | C | D | E | F |.....
1 | . | 4 | . | . | . | . |
2 | . | . | . | . | . | . |
3 | Day | 1 | 2 | 3 | 4 | 5 |.........| 31 |
4 | Fruit | . | . | . | . | . |
5 | Apple | 20 | 12 | 30 | 7 | 3 |.........| 10 |
6 | Orange | 10 | 23 | 45 | 17 | 5 |.........| 20 |
7 | Pear | 5 | 5 | 5 | 5 | 5 |.........| 5 |
8 | Mango | 3 | 2 | 3 | 2 | 3 |.........| 3 |

In cell B1, if I enter 4 (sales amount as of the 4th day of the month), my formula should be able to return
Basically it should be able to find using 2 criteria (1st one being the day of the month, and the 2nd one being Fruit name)

Apple : 69
Orange : 95
Pear : 20
Mango : 10

Hi,

Please upload the workbook.

Have you considered a Pivot Table which may well give you what you want without the need for formulae?

Try this...

Data Range

	A	B	C	D	E	F	G
1		4
2	------	------	------	------	------	------	------
3
4	Day	1	2	3	4	5	6
5	Item1	64	29	65	57	73	90
6	Item2	3	56	32	25	4	68
7	Item3	27	5	52	28	54	51
8
9
10	Item1	215
11	Item2	116
12	Item3	112

This formula entered in B10 and copied down:

=SUM(INDEX(B$5:G$7,MATCH(A10,A$5:A$7,0),1):INDEX(B$5:G$7,MATCH(A10,A$5:A$7,0),B$1))

If B1 is an empty cell the formula will sum the entire range.