Can I divide one colums of data into two sets of bins to prepare an array for contour

Hello All,

I have a pretty complicated Excel problem that I've been trying to solve using array formulas without success. I am a total novice at VBA and so ideally a formula approach would suit me best to fix this but I'm willing to try anything!

I have a set of data from an experiment which consists of a column of sizes and another with a measurement. I have managed to get the size data split into bins using the following array formula:

=FREQUENCY(size,I3:I52)

What I really want is to be able to have another set of bins with the measurement in and then only count the size of the measurements of a given value. Well... from here it went a bit crazy! I tried many things with varying success (please bear in mind that I was trying most of these for the first time):

Dcount - just gave total count in all bins
Countif (AND) - was hoping it would only count the size if the measurement was between two values but couldn't get the syntax right to even see if it was right!
Count(if(and( - Same goal as above but again the sytax wasn't good for me

All of these still involve me manually assigning the measurement bins and then using a round about way of saying if between these to numbers. I
Basically it wouild be nice to be able to just have =FREQUENCY(size,I3:I52)AND(measurement,K3:z3) obviously wrong syntax but I hope it gets the point across. The overall aim is to have the number of each measurement value for each size and then plot this on a contour plot. The instrument that does this at the moment does it all in MSDOS and so I'm trying for an update.

I look forward to any advice you can give me

Cheers

Jarvice

Jarvice,

Welcome to the forum!
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.

maybe something like this?see sheet 2