# SUMIF AND statement

#### edwardtong694

##### Board Regular
Hi Guys,

Sorry for posting such a simple question, for some reason I cant seem to get this to work.

I have three rows of data.

A B C
1 Ed Apple 50p
2 Pear 25p
3 Pear 27p
4 Orange 20p
5 Dave Apple 50p
6 Pear 25p

And so on...

What I need is a formula which will calculate the total cost Ed has spent on Pears or Apples etc..

So I will have a field which says Ed Pear spend: and the formula will be something like..IF A=ED and B=Pear then Sum collumn C for those values.

Hope this makes sense.

Thanks

Ed

### Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

#### gaz_chops

##### Well-known Member
Try

=sumifs(\$C\$1:\$C\$6,\$A\$1:\$A\$6,"Ed",\$B\$1:\$B\$6,"Pear")

Change "Ed" & "Pear" to the cell references that contain them.

#### edwardtong694

##### Board Regular
Thats done the trick!

Thanks Gaz

#### gaz_chops

##### Well-known Member
You're welcome, thanks for the feedback.

Replies
13
Views
471
Replies
1
Views
306
Replies
3
Views
251
Replies
10
Views
914
Replies
1
Views
655

1,195,671
Messages
6,011,077
Members
441,581
Latest member
rp4717

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