if then statement

  • Thread starter Thread starter smorzando
  • Start date Start date
S

smorzando

on a related note to my earlier post, but on another
project, I have a worksheet that looks at financial
holdings. If the cell reads "M", then I would like the
data from that row to be pulled into another worksheet and
the monetary total from the various "M" rows to be summed.

How can this be done?

Also, can one create a pull down menu?
 
You would go into "another worksheet" and put a formua there like

IF(Firstworksheet!C1="M",Firstworksheet!D1,"")

(if D1 contains the monetary value you want to pull over).

then you can sum them up on that worksheet or anywhere else.
 
thanks much. i'll give it a try.

-----Original Message-----
You would go into "another worksheet" and put a formua there like

IF(Firstworksheet!C1="M",Firstworksheet!D1,"")

(if D1 contains the monetary value you want to pull over).

then you can sum them up on that worksheet or anywhere else.





.
Click to expand...
 
and if i want to cover a whole column at once, how would i
write the IF statement?


is that right, given C1 and F1 as the first and last
members of the group?

And will excel populate, or is this something I should be
doing in another program?
 
Do you mean a whole row at once? C1:F1 is more part of a row than a column.
You can COUNT the occurences of "M" in a range, and then bring the value
over. As far as I know, you cannot set the formula as you have to bring over
data that will be automatically spread over various columns.

It depends on how many "M"s you require in that range C1:F1 in order to
bring the $ over to the new worksheet. If it is just 1 M,
IF(COUNTIF(Firstworksheet!c1:f1,"M")=1,Firstworksheet!D1)

You are asking whether excel will produce output in more than 1 cell after
you enter data? I think some of the formulas do that but I could be wrong. I
don't think that's necessary here.

To provide more specific advice you should write up an example what your
data looks like and what you want it to do. It is not necessary in this
seemingly simple case to have excel populate cells. Just set the range where
you want it, and copy the formula over yourself for as far as you want to
bring data over.
 
Back
Top