Hello Forum, just looking for a little help with a SUMPRODUCT formula. I've included a very simple example of my data. In cell C13 is where I need to place my formula. I need the formula to reference A13 and B13, and give me the total in C13. I may be putting in different dates in B13 and even different departments in A13. I hope this makes sense. I guess I could use a HLOOKUP formula, but I really wanted to see if I could accomplish it with a SUMPRODUCT. Thank you for taking a look at my post and any comments would be greatly appreciated. --Ben
<TBODY>
</TBODY>
A | B | C | D | E | |
1 | Dept: | Jan-13 | Feb-13 | Mar-13 | Apr-13 |
2 | Mgt | 1 | 1 | 1 | 1 |
3 | Mgt | 1 | 1 | ||
4 | Com | 1 | 1 | 1 | 1 |
5 | Mgt | 1 | 1 | ||
6 | Mgt | 1 | 1 | ||
7 | Com | 1 | 1 | 1 | 1 |
8 | Mgt | 1 | 1 | ||
9 | Com | 1 | |||
10 | Com | 1 | 1 | 1 | |
11 | |||||
12 | Dept: | Date: | Count: | ||
13 | Mgt | Mar-13 | 4 |
<TBODY>
</TBODY>