Google Sheets - IF columns contains text and another columns contains number return total value of n-CodePudding

Home > Back-end > Google Sheets - IF columns contains text and another columns contains number return total value of n

Google Sheets - IF columns contains text and another columns contains number return total value of n

Time：01-08

I am trying to see if I am able to get the hours from one column only if it matches a word that is another column.

For example in the sheet link attached, if the word is Operations (Column A) I want to get the sum of all the hours (Column B) that correlate with that word.

Page link：https//www.codepudding.com/Backend/665325.html

Prev:Use cell content as values for a weighted.average formula in google sheets

Next:Automatically move focus to cell in Google Sheets

Tags：

if-statementgoogle-sheetstextsumnumbers

Links：
CodePudding