Sumif/Counif/Vlookup--NOT SURE??

**DaFonz01** · 03-05-2010, 01:05 PM

I have 2 columns that I am trying to pull information from:

Row 1 Row2
A: Columbus Detail
B: Columbus Blank
C: Columbus Detail
D: Tulsa Detail

I am looking for a formula that will count how many projects are "Detail and Blank - from Row 2" and are from "Columbus--Row 1". I have been playing around with this for too long and cant figure it out. So I am looking for a formula that will show me "3"

Thanks for you help!

**JBeaucaire** · 03-05-2010, 02:10 PM

Correcting your syntax to columns, I would suggest something like:

=SUMPRODUCT(--(A2:A5="Columbus"), --($B$2:$B$5="Detail")+($B$2:$B$5="Blank"))

Please Login or Register  to view this content.

...or based on this layout:

=SUMPRODUCT(--(A2:A5=D2), --($B$2:$B$5="Detail")+($B$2:$B$5="Blank"))

**6StringJazzer** · 03-05-2010, 02:10 PM

I think you have your rows and columns a bit confused; columns are A, B, C and rows are 1, 2, 3. If your data is organized as shown, they are in Column A and Column B, and rows 1-4.

These formulas will give you what you want:

=COUNTIF(B:B,"Detail")
=COUNTIF(B:B,"Blank")
=COUNTIF(A:A,"Columbus")

**6StringJazzer** · 03-05-2010, 02:13 PM

On seeing JBeaucaire's solution I realize I may have misunderstood what is being asked for; I guess you need a single formula that combines all those conditions. But if everything is either Detail or Blank, why not just count occurrences of Columbus?

**royUK** · 03-05-2010, 02:31 PM

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

**DaFonz01** · 03-05-2010, 04:10 PM

Sorry Guys, I did not mean to break any rules. I was just under a deadline today and needed some help and posted the question on another forum also.

JBeaucaire, I owe you. You solved it! Thanks

**NBVC** · 03-05-2010, 04:13 PM

Originally Posted by DaFonz01

Sorry Guys, I did not mean to break any rules. I was just under a deadline today and needed some help and posted the question on another forum also.

JBeaucaire, I owe you. You solved it! Thanks

That too would be breaking a rule... you need to post links to crossposts...