Need Simple Cell Formula

[windsurfit]

Hello All, I believe all I need is a formula for this but can't nail it.

I have a sheet with multiple columns of data.

I need a Subtotal value to return (Placed in cell F3) based on the text entry word in a given range (Column J) and the corresponding numeric value in (Column K).

Every cell value containing the word "Current" in column J will have a numeric value in same row of K. If the word is "Prospect" then the subtotal value remains $0.00

So for example when J9 has the Word "Current" and K9 has the value 100.00 then F3 will result in the subtotal and display $100.00
IF-- J9 has the word 'Prospect" and K9 has the value 100.00 then F3 will result and display $0.00

Two running examples:

J9 is Current K9 is 100.00
j10 is Current K10 is 25.00
J11 is Prospect K11 is 25.00

The result from above formula in F3 would be $125.00


J9 is Prospect K9 is 100.00
j10 is Current K10 is 25.00
J11 is Prospect K11 is 25.00

The result from above formula in F3 would be $25.00



This is for all data on all rows as my database grows where it finds the "matched" text.

 

[Marcelo Branco]

Maybe...

=SUMIF(J9:J11,"Current",K9:K11)

M.

 

[Roderick_E]

=SUMIF(J:J,"Current",K:K)

 

[windsurfit]

Thanks, that did it..