Small Excel Question Not Worth Its Own Thread

Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > The Cavern of COBOL > Small Excel Question Not Worth Its Own Thread

mistermojo: Jul 3, 2004

Ok, so I use this function to count across a row:

=(COUNTIF(A22:AB22, "E") + COUNTIF(A22:AB22, "S") + COUNTIF(A22:AB22, "U"))

what I want to do is use that kind of function to count across each row of x number of columns and sum it up. (so instead of A22:AB22 it would be A22:AB22, A23:AB23 etc)

How would I do that?

# ¿ Mar 25, 2010 19:39

Adbot: ADBOT LOVES YOU

# ¿ May 6, 2024 10:11

mistermojo: Jul 3, 2004

Ok I spaced out there for a second and forgot its as easy as A22:AB26 so never mind

but what does 1, 0 in your function do?

# ¿ Mar 25, 2010 19:45

mistermojo: Jul 3, 2004

another (probably) stupid question: How do I get the print titles (same row on each page) to display in Normal view?

# ¿ Apr 14, 2010 19:16

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > The Cavern of COBOL > Small Excel Question Not Worth Its Own Thread