Hi all,

Not sure if this can be done, but I am looking to sum quantities carried out
in a certain period (month no. reference, for which there could be up to 25
columns of data per month) & then also against certain items of work in the
rows (for which there could be 50+ work categories.
eg.
A B C D E F G H
1 Month 1 1 1 1 1 2 2
2 Supply 56
3 Make 12 20 18 6
4 Package 10 10 10 10 10 6
5 Sell 5 5 3 2 4 4 4

Hopefully that comes out okay.
So I am after a formula that will SUMIF (or equivalent) All things 'Made' in
month 1, and then also all things 'Packaged' in month 1, etc
Only drama is: Row references aren't fixed. Excel will have to first lookup
what row number 'Make' is in and then sum all values in that row where row A
= 1.
Hopefully I have explained this properly.