|If your data looks like this:|
A B C D
1) Category 10-Oct 10-Nov 10-Dec
2) Production 10 10 10
3) Selling 2 2 2
4) Markeeting 1 1 1
and your using this formula:
The structure of the =SUMIF() function is:
Your Range of things to be examined is $A$1 through $D$3 which leaves you one row short of what you will need if you intend to sum all of your categories, it should be A1 through D4.
Your Criteria to be matched is $A$1 which is the Column heading Category
If I use the above layout of data, then the formula returns the Date Heading in Column B, which is 40461.
To return the totals for the Category Production the formula should be changed to:
This will return the number 10 from Column B, Cell 2.
To return the totals for the Category Selling the formula should be changed to:
I would advise against using B:B, the whole B column as a range to total.
If sometime in the future a spurious figure gets added to column B it will return a false total.
Better off using the same rows as in your Range of things to be examined, IE B1:B4
Make sure the cell where you place the formula is formatted correctly.