Excel Formula Question 3

[jfussell]

I have a formula question and would appreciate some assistance on this.

I have a spreadsheet that tracks our company stocks. In particularly 1 column that has the number of stocks owned (number), and the other column how the stock was issued (text). I would like to have the cell F150 give me a total SUM of stocks in column F by only summming up all cells in column H that says "Grant". Is there an easy way/formula to accomplish this?

Thanks.

 

[AnotherHiggins]

Assuming column F contains your numbers of stock owned, this should work:

[COLOR=blue white]=sumproduct((H1:h149="Grant")*(f1:f149))[/color]

[tt]__________________________________________
My name is John, and I approved this post.[/tt]

To get the best answers fast, please read faq181-2886

 

[Molby]

Use Sumif

=SUMIF(B1:B3,"GRANT",A1:A3)

Where B1:B3 contains your text, Grant is the text you are evaluting and A1:A3 is the range of cells that you want to sum

 

[SkipVought]

Hi,

Use the SUMPRODUCT Function
[tt]
=SUMPRODUCT((G2:G999="Grant")*(F2:F999))
[/tt]
assuming that you range is from row 2 thru 999

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}

 

[jfussell]

Wow, thanks for the quick responses. The formula worked!! Everyone gets a star!!