Count Function problem

[romsyam]

This is probably an easy one for you people. Any help greatly appreaciated :-)

I've got four columns on a spread sheet. The first two columns are related and the second two are related.

I'd like to find the formula that will find out of the first two columns, a set of numbers, and a different set of numbers in the lat two columns.

So for instance I want to find where column a and b have 3 and 7 in and where column c and d might have 4 and 6.

Hope someone can understand me.

Thanks in advance

[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!

[Cutter]

In another column you could use this formula:

=IF(AND(A2=3,B2=7,C2=4,D2=6),"X","") dragged down the length of your range (and assumes your range starts in row 2)

replace the actual numbers with cell references that hold the numbers to make it more flexible.

You could use a COUNTIF() in another cell to tell you how many "X"'s are returned

[romsyam]

Thanks Cutter I will try it when I get home :-)