SUMPRODUCT

[trusty]

Could anyone tell me what I am doing wrong with the below formula. Its been giving me problems all afternoon.

thanks in advance


=SUMPRODUCT(--('All Markets'!$A$2:$A$235='Summary'!$B$1);--('All Markets'!$B$2:$B$235='Summary'!$B$9);'All Markets'!$k$2:$k$235)

I should add I am looking for a code in column A of All markets which is listed in summary b1, and a date in the b column of "All markets" which is listed in b9. I want it to sum all the appropriate values in all markets k

 

[Aladin Akyurek]

Could anyone tell me what I am doing wrong with the below formula. Its been giving me problems all afternoon.

thanks in advance


=SUMPRODUCT(--('All Markets'!$A$2:$A$235='Summary'!$B$1);--('All Markets'!$B$2:$B$235='Summary'!$B$9);'All Markets'!$k$2:$k$235)

I should add I am looking for a code in column A of All markets which is listed in summary b1, and a date in the b column of "All markets" which is listed in b9. I want it to sum all the appropriate values in all markets k

What are the problems that you're having with this formula which appears to be set up correctly syntaxwise, assuming that your local version requires semi-colon as list separator?

 

[trusty]

Thanks I've managed to solve the problem myself. An apostrophe was missing from one of the sheet names