# sumif col 1 true & col2 true sum col3 matches

#### larper

##### Board Regular
Sometimes it doen't pay to come back from lunch. However it is Friday so we may have a chance.

Any ways I need to sum up freigh Cost in col3, when col 1 & col2 are ture to conditions.

And oh by the way I need to Count this also.

Any help? Thanks?

### Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
try this...this is a set up i have that does what i think your trying to do

=sumproduct((A1:A56=90316469)*(B1:B56="D")*(C1:C56))
columns A nd B are your criteria columns...column C has the values u want sum'ed up

for the count try this:

=sumproduct((A1:A56="D")*(A1:A56="D")*(B1:B56=90316469)*(B1:B56=90316469))

of course i filled the columns in with my own criteria...just replace my columns and criteria with yours and all should work well

u may have to add quotes to the numbers for example "90316469"....or '90316469'

anyway..let me know if this works

Marq

Replies
20
Views
922
Replies
1
Views
603
Replies
3
Views
846
Replies
15
Views
1K
Replies
4
Views
169

1,206,943
Messages
6,075,776
Members
446,154
Latest member
Dirk46

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