Issues creating formulas

[Ken G]

I have a spreadsheet with upper portion is the analysis and lower portion
ismanual data input....Rows 1 thru 35 are the upper portion..row 36 thur
infinity say 2000 rows is the manual data input.
Problem formula #1
I want the fourmula to do this:
look at cell H 37 determine it is a $value > $50.00..place a "W" in cell Q37
and sum that $ value in cell "F9" as a sum
look at cell "H 37" determine it is a $value > $-50.00 place a "L" in cell
Q37 and sum that value in cell "I10" as a sum
look at cell "H 37" determine it is a $value > $0.00 but less than $50.00
and place an "X" in cell Q37 and place its value in cell "F11" as a sum
look at cell H37 determine its $ value < $-0.00 but not greater than $-50.00
and place an "X in Q37 and place its value in cell "I11"
look at cell "H 37" if its $value is > $-50.00 then place an "SO" in cell
"Q37" and place its value in cell "I12"..

Formula #2...
Look in col P ..rows 35 thru infinity say 2000 rows...and look for either an
"S" or and "L"..this is a manual input...

count if= and "L" count that and place the count in cell "E14" and place
the $value of of the corresponding row value in "H" if> $0.00as a sum in "F14"

count if and "L" count that and place the count in cell "H14" and place the
$ value in the corresponding row value in "H" if < $0.00 as a sum in"I14"..

Does that make sense....or do I write the ending value in its cell and
create the formula to look in the corresponding...for instance...
in cell "E14" I want it to look in all cell of ($P35:$P2000) if it is an "L"
count them and place value in "E14" then if an "L" is the corresponding row
cell "H" value >$0.00 then sum in "F14"..if the corresponding row value in
"H" < $0.00 then then place that count in "H14 and the corresponding row
value of "H" in"I 14"
countif= and "S" count that and place the count # in cell "E15"..and place
the $value of the courresponding row value in "H" if > $0.00 as a sum in cell
"F15"

count if and "S" count that and place the count # in cell "H 15" if the
corresponding $value in the corresponding row in "H" if < $0.00 as a sum in
cell "I 15"
count if "L"

Does that make sense....or do I write the ending value in its cell and
create the formula to look in the corresponding row and cell....for
instance...
in cell "E14" I want it to look in all cell of ($P35:$P2000) if it is an "L"
count them and place value in "E14" then if an "L" is the corresponding row
cell "H" value >$0.00 then sum in "F14"..if the corresponding row value in
"H" < $0.00 then then place that count in "H14 and the corresponding row
value of "H" in"I 14"

 

[Ken G]

here is another way to look at the problem with Formula #2:
In cell "E 14" I want it to look at all cells in P column..($P35:$P2000)
look for all cells with an "L".. count all cells that have a value in cell
"H" (corresponding row ) that have value > $0.00..put the count in cell "E
14" and the sum of the value in "H" in cell "F 14" , if the value in "H" is
less that <$0.00 count all the "L" and place that # in cell"H 14".and put
that value in cell "I 14"..and do the same formula in cell "E 15"for any
cell that has a "S" in ($P35:$P2000)
place the count in "E 15" and place the $ value in "H" in cell"F 15" if >
$0.00 and place the count of "S" in cell "H15" and the value in "H" in cell"
I 15" if < $0.00

 

[John]

Hi Ken
Lets just take one problem at a time (Problem Formula #1)
Just a comment; formulas don't send information to cells, they pull
information.
Now =if(H37=50,"W","") this formula will test H37 if it's equal to 50, if
yes, it will place the letter W in cell Q37 but this is were the formula
must be so You can't sent more information to F9 or elsewhere.
For you to explain use these symbols :> greater then: < smaller then : =
equal to.
I'm not sure what you mean by : $-0.00 or $0.00 but less than $50.00 .
Just a note I mentioned formula don't push information but a macro would do
it.
Just not clear what you want.
HTH
John