Only using the correct cell for the sum

[craigwojo]

Hi Everyone,

I need a formula for the following:
I have a number of cells that have numbers in them. Each one of thos
cells has a cell next to it for checking off (I enter a certain lette
in the cell) to confirm if the job (numbered cell) was completed.
Hopefully you understood that.
Well what I need is I need a cell that takes all the cells with number
see if it was checked and enters a total amount in the cell.

I’ll try to explain:

Column A---------Column B
122---------------------P
144---------------------
121---------------------
104---------------------P
254---------------------P
100---------------------
275---------------------P

Column N
755

Column N will only tally up the numbers that have the letter P next t
them and ignore the other numbers in Column A.

Any assistance will be appreciated.

Thank you,
Crai

 

[Ken Wright]

=SUMIF(B2:B100,"P",A2:A100)

or

=SUMPRODUCT((B2:B100="P")*(A2:A100))