Microsoft Excel Gurus....

[maverick99]

I have a few questions for anyone qell-versed in Mircosoft Excel. I want to know if something is possible.

Can a set up a cell so that the value increases based on another cell. Say make a1 go up one for every time there is a value of 2 in blocks A2,A3, or A4.

In a sports analogy to try to make it clearer.... Lets say I was running a stat sheet. I have one Cell for the total number of doubles. Then I have four different cells for each of a players' at bats for a particular game. Can I make the doubles cell increase by one every time there is a "2B" present in one of the at bat cells?

[gschwendt]

Re: Microsoft Excel Gurus....

=(IF(A2="2B",1,0)+IF(A3="2B",1,0)+IF(A4="2B",1,0))

[maverick99]

Re: Microsoft Excel Gurus....

=(IF(A2="2B",1,0)+IF(A3="2B",1,0)+IF(A4="2B",1,0))

Sweet thanks. Along those same lines can I have the nu,ber increase if a cell CONTAINS the 2B but also has another word or digit....I.E. Back to my baseball example which seems to work well for this....Say a Cell says RBI 2B.....can I have the 2B's Cell still increase because the cell in question CONTAINS the "2b" but is not limited to it? Or have the cell increase should another cell have one of multiple things in it? Say make a hits box increase because another cell says EITHER 1B or 2B?

And also, can I make the sum of a cell increase by one due to another cell simply having any character at all in it?

[bryan_05]

Re: Microsoft Excel Gurus....

you really should just play around with the if statements , send me your spreadsheet if no one comes in to the store I can play around with it.

[bryan_05]

Re: Microsoft Excel Gurus....

rather than using =if above, =countif(a2:a4, "2b") is much smaller

[bryan_05]

Re: Microsoft Excel Gurus....

Sweet thanks. Along those same lines can I have the nu,ber increase if a cell CONTAINS the 2B but also has another word or digit....I.E. Back to my baseball example which seems to work well for this....Say a Cell says RBI 2B.....can I have the 2B's Cell still increase because the cell in question CONTAINS the "2b" but is not limited to it?

that is going to take some elementary programming with Visual Basic I think. I can't do it

Or have the cell increase should another cell have one of multiple things in it? Say make a hits box increase because another cell says EITHER 1B or 2B?

Yes use =countif(a2:a4,1)+countif(a2:a4,2)

And also, can I make the sum of a cell increase by one due to another cell simply having any character at all in it?

=count(a2:a4)