# Formula to summarize the multiplication results of two columns if criteria met

#### lilloscar

##### New Member
This First formula make half of the work:

Code:
``=SUMPRODUCT(--ISNUMBER(FIND("X",\$A\$1:\$A\$3)),\$B\$1:\$B\$3,\$E\$1:\$E\$3)``

The result intended to reach in the example is 60, the given formula only works with one column, in this case B, so C and D is missed.

A second formula summarize what is needed in the above one.

Code:
``=SUMPRODUCT((ISNUMBER(SEARCH("X",\$A\$1:\$A\$3)))*(\$B\$1:D3))``

These 2 are the closest ways I can reach, can they be mixed?

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

#### Special-K99

##### Well-known Member
Does this work?
=SUMPRODUCT((ISNUMBER(SEARCH("X",\$A\$1:\$A\$3)))*(\$B\$1:D3)*(\$E1\$E3))

#### lilloscar

##### New Member
Does this work?
=SUMPRODUCT((ISNUMBER(SEARCH("X",\$A\$1:\$A\$3)))*(\$B\$1:D3)*(\$E1\$E3))

@Special-K99
Awsome, I appreciate it.

Replies
0
Views
202
Replies
4
Views
165
Replies
2
Views
301
Replies
3
Views
215
Replies
4
Views
126

1,191,219
Messages
5,985,338
Members
439,958
Latest member
qb0000

### 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.

### Which adblocker are you using?

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

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