Count data in isolated range

[AGar]

Hi.

I'm pretty novice with Excel, and I'm trying to do a bit of a datamining project. I'm currently at a standstill.

I have about 250 lines worth of data that I extracted, and now I'm trying to count out certain trends among the data.

What I'm looking to do is a two step process.

I need to go through one column of data and count the instances of a certain value. Let's call it "A". Then I need to go through another column of data to find out if a certain value, we'll call it "B", appears in the cell adjacent. So basically I need to go down a list finding if the combination of A B appears in cells in columns D and E.

I think I got that across clearly.

Thanks in advance.

[stanleydgromjr]

AGar,

Welcome to the Excel Forum.

Try in cell F1:
=SUMPRODUCT(--($D$1:$D$250="A"),--($E$1:$E$250="B"))

[AGar]

AGar,

Welcome to the Excel Forum.

Try in cell F1:
=SUMPRODUCT(--($D$1:$D$250="A"),--($E$1:$E$250="B"))

Hi stanley. Thanks for the quick reply, but this just didn't work out for me.

I'll try and be more clear with my situation.

I'm tracking the data from a particular game that has two parties and four randomized setups. In column B (B7:B262, to be exact) I have the setups of each particular game, labeled as A, B, C or D. In column C (C7:C262) I have the winning party of each game, labeled as M or T. What I am trying to do is search through column B and find out how many times "A" appears and then search column C for the same row values to see how many times "M" appears. I hope that makes sense.

[teylyn]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[AGar]

Thank you all. It appears that I've found a work around that suffices for now, but thanks for the attempts to help me.

[teylyn]

It appears that I've found a work around that suffices for now,

It would be only fair to those who tried to help you as well as those searching the forum for solutions, if you could share your findings.

then, you should mark this thread as solved.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save