(SOLVED) Can't get sumproduct formula to work

[friend11_6]

Hi.

COuld someone let me know what is wrong with my sumproduct formula in the attached file? Thanks!

Friend

[shg]

Any formula with #N/A references not wrapped in ISNA or ISERROR will return #N/A.

Please take a few minutes to read the forum rules, and then amend your thread title; there's only one useful search term in it, and the rest is noise.

[martindwilson]

and while you're at it attach sheet not image. can't test functions in images!

[zbor]

Probably he don't need quick answer
Few days explaining problem, few days explaining picture and after that posting example

[friend11_6]

Hi.

Sorry, here is the file again.

Thanks.

[DonkeyOte]

This:

Please Login or Register  to view this content.

works ok for me but given you're using XL2007 you could use SUMIFS which would be more efficient (not backwards compatible)

Please Login or Register  to view this content.

If your source range (6. Review Category for trans') contains error values you run the risk of course get errors back in return... for ex. if your VLOOKUP in column L returns #N/A the SUMPRODUCT will also return #N/A (as already pointed out by shg in post#2)... if the value column contains #VALUE! errors etc both SUMIFS & SUMPRODUCT would return #VALUE! error etc... so name of the game if you get an error in your results is to check your source values and handle accordingly (ie in the original formula not the aggregation formulae)

[friend11_6]

Thanks! The sumifs worked. Fabulous.