# Sumif's Criteria Problem

#### specs

##### New Member
i tried sumif but seem to have a problem
e.g =SUMIF(A1:A3,"AJ",B1:B3)

A--------------B
_______________
AJ SMITH------2
MIKE GDE------1
AJ JOHNSON------3

is there anyway to have the the criteria matched rows1 and 3, which have a AJ word. so i can get the value of 5?

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
You can use a wildcard like this:

=SUMIF(A1:A3,"AJ*",B1:B3)

Great, Thanks alot Andrew.

Replies
2
Views
691
Replies
2
Views
83
Replies
12
Views
422
Replies
21
Views
829
Replies
10
Views
392

1,206,971
Messages
6,075,925
Members
446,170
Latest member
zzzz02

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

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