SUMPRODUCT

trusty

New Member
Joined
Feb 23, 2005
Messages
30
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
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
trusty said:
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

New Member
Joined
Feb 23, 2005
Messages
30
Thanks I've managed to solve the problem myself. An apostrophe was missing from one of the sheet names :oops:
 

Watch MrExcel Video

Forum statistics

Threads
1,123,400
Messages
5,601,467
Members
414,452
Latest member
Dannysamworth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top