Only using the correct cell for the sum
 

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

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

or

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"craigwojo" wrote in message
...

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



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004