CODEWITHSUNDEEP
excel-formula
Ro-berg
Ro-berg

Reputation: 1

Building an Excel Formula

I am brand new to building formulas in excel (other than the easy stuff). I am trying one that is fairly simple, and I am close but can't quite get it to work!

I need to sum the values in column H, only if the value in column F is equal to the value in a specific cell. Values in column H are numerical, values in F and the specific cell are words.

So if the number in column H is listed as "Ontario" I need the sum. Numbers in Column H can be any whole, positive number.

Thanks for any help!

Upvotes: 0

Views: 55

Answers (1)

Scott Craner
Scott Craner

Reputation: 152660

You want SUMIF():

=SUMIF(F:F,"Ontario",H:H)

Change "Ontario" to the cell reference.

Upvotes: 2

Related Questions