Hi Everyone,

I need a formula for the following:
I have a number of cells that have numbers in them. Each one of those
cells has a cell next to it for checking off (I enter a certain letter
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 numbers
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 to
them and ignore the other numbers in Column A.

Any assistance will be appreciated.

Thank you,
Craig


--
craigwojo
------------------------------------------------------------------------
craigwojo's Profile: http://www.excelforum.com/member.php...o&userid=13767
View this thread: http://www.excelforum.com/showthread...hreadid=276092