SUMIF AND statement

[edwardtong694]

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

 

[gaz_chops]

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]

Thats done the trick!

Thanks Gaz

 

[gaz_chops]

You're welcome, thanks for the feedback.