Lookup / Count-Sum

**AVFD215** · 03-27-2012, 10:09 PM

I need some Excel Formula Help. 2007.
Sheet 1:
Column N3 to N700 - Contains A - M - (Text)
Columns S3:S700 & T3:T700 - Contains $ Values
Sheet 2:
B5:B17 = A (Through M)(Text)
Sheet 2, C5 Needs to be the Count of Column S minus Count of Column T per Sheet 2, B5 (A)

I also need the Sum for this same set.

Thanks in advance.
Mike

**Paul** · 03-27-2012, 10:14 PM

Hi Mike, welcome to the forum.

Can you please provide a small sample workbook? I'm not exactly following what types of data exist and it would be good to see what your expected results would be based on the sample data.

**AVFD215** · 03-27-2012, 10:25 PM

N S T
CAT. Estimated $ Completed $
B $12,650
A $5,000 $5,000

Count the number of "A"s that are Estimated but not Completed

**Paul** · 03-27-2012, 10:29 PM

Do you see now why trying to do "show" your data within a post doesn't work so well?

Just a wild guess since I'm still not sure of your data... maybe:

=COUNTIFS(N:N,"A",T:T,"")

This counts the number of entries where column N contains the letter A and column T is blank.

**AVFD215** · 03-27-2012, 11:48 PM

That works good, but I messed up and forgot one more discriminator.
Column U:U needs to be subtracted from that value.

=COUNTIFS(N:N,"A",T:T-U:U),"")

Sorry about that.

**Paul** · 03-28-2012, 12:28 AM

Again... My formula counts all instances of when column N is the letter "A" and column T is empty/blank. Is it your intention to simply subtract the value in U for those rows from 0 each time? Because that's what is going to happen.

I seriously, seriously, seriously recommend posting a workbook. It will take you about 30 seconds to create and 30 seconds to post. Show your data as it's currently laid out, and show where you want the results and what those results should be - and why.