CODEWITHSUNDEEP
excelvba
KomVVi
KomVVi

Reputation: 17

sumifs function with multiple string in the cells evaluated

I have a question regarding sumifs function,

If I want to sum a column for exemple on time spend doing some sport, In column A I have "Sport.tennis", "Sport.swimming", "School.homework" and in column B I have "30", "20", "50".

Is it possible that the function sumifs, sum the time in colonne B if there is only "Sport" in column A ?

I've tried but it return 0, what should I do ?

Upvotes: 0

Views: 40

Answers (1)

EEM
EEM

Reputation: 6660

Assuming your data is located at [A1:B3] try this formula:

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

Upvotes: 2

Related Questions