CODEWITHSUNDEEP
excelexcel-formulaexcel-2007
user5500328
user5500328

Reputation: 61

Sum of all values in one column considering two others

I want to find the (Value Column) but it should consider the date (Column A) and the name of the person (Column B) who submitted the data.

DATA Sheet Sample

enter image description here

Upvotes: 0

Views: 46

Answers (1)

pnuts
pnuts

Reputation: 59475

Please try SUMIFS, for example: 

=SUMIFS(C:C,B:B,"Joseph",A:A,"11/2/2015")

SO33480055 example

Upvotes: 1

Related Questions