=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