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>
