IF/AND Statement & searching through select data...

  • Thread starter Thread starter Shhhh
  • Start date Start date
S

Shhhh

Hello all,

I'm going to try to explain my problem in plain english and hopefully
you great folks can help me translate into excel!...

I have a sheet with data in groups with blank spaces in between... so
for example:

Row 1 data
Row 2 data
.....
Row 8 data
blank
blank
Row 11 data
Row 12 data
etc...

I want a formula that say if certain criteria is met, for excel to
search in JUST THOSE ROWS CONNECTED for specific text:

So for example: in cell K13 I have this formula:
=IF(A13="","",IF(AND(B13="Stock",C13="BTO"),0,I13*(F13*100)))

Where it says I13*(F13*100) I want to include another if and statement
that says IF B says "Stock", and column C says "STC" then search in
the cells in this batch of data (between the blank rows) for a row
that has B "Stock" and C "BTO" and subtract this row from the "STO"
row. otherwise use the I13*(F13*100)

I am sure I didn't word this perfectly and I apologize, but Is what
I'm asking for possible? I thank you all for your help!!
 
Hello all,

I'm going to try to explain my problem in plain english and hopefully
you great folks can help me translate into excel!...

I have a sheet with data in groups with blank spaces in between... so
for example:

Row 1 data
Row 2 data
....
Row 8 data
blank
blank
Row 11 data
Row 12 data
etc...

I want a formula that say if certain criteria is met, for excel to
search in JUST THOSE ROWS CONNECTED for specific text:

So for example: in cell K13 I have this formula:
=IF(A13="","",IF(AND(B13="Stock",C13="BTO"),0,I13*(F13*100)))

Where it says I13*(F13*100) I want to include another if and statement
that says IF B says "Stock", and column C says "STC" then search in
the cells in this batch of data (between the blank rows) for a row
that has B "Stock" and C "BTO" and subtract this row from the "STO"
row. otherwise use the  I13*(F13*100)

I am sure I didn't word this perfectly and I apologize, but Is what
I'm asking for possible? I thank you all for your help!!
Click to expand...

I'm really at a loss here, if anyone could offer any help I'd be very
grateful!
 
Back
Top