Sumifs Vs Sumproduct

You can't use SUMIFS in versions earlier than 2007 so you need SUMPRODUCT

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

With SUMPRODUCT in Excel 2003 you need to use a specific range (not the whole column), so something like this should work

=SUMPRODUCT(D1:D100,(A1:A100="BCB12")*(E1:E100=201005))

extend ranges if necessary. I assume that 201005 is numeric, hence no quotes but if column E contains text formatted values you need "201005"

Just a suggestion. Converting the data to a List would mean you don't need to worry about the data expanding & you can refer to columns in the formula

Why not post the formula, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Non-array formula would be: =SUMPRODUCT((A6:A27=A6)*(E6:E27=E6)*(D6:D27))

Dom