CODEWITHSUNDEEP
excelexcel-formula
user4041331
user4041331

Reputation:

Sum if 2 columns met the values of another column

Here are my values: C1 is set by other values C14:C214 is set by a drop down box A14:A214 is a typed in Date If both Critera are met I want to sum H14:H214

=SUM(IF((TimeLog!C14:C214="*Vitamin Shoppe#*")+(TimeLog!A14:A214=C1),TimeLog!H14:H214))

Thanks in advance

Upvotes: 0

Views: 43

Answers (1)

user4041331
user4041331

Reputation:

Very good advice, I check ed "hints" as you type the code in and matched it and it worked! =SUMIFS(TimeLog!H14:H214, TimeLog!C14:C214, "*Vitamin Shoppe#*", TimeLog!A14:A214,C1)

Upvotes: 1

Related Questions