A conditional sum

[Mike Waters]

Hello,
I have a spreadsheet that has 3 pages two pages to
it. The pages have between 10 and 20 columns, and can
have upto 1000 rows of data in them. I currently have
some conditional formating set up based on whats in column
A. What I am looking to do now though is to do sums on
certain rows based on what the value in column A is. I
know I can do it by using an if function, but with it
being 1000 rows that I need to add, that would take a lot
of typing. Does anyone know of a way to set up a sum
formula that will only add certain cells based on the
condition of another cell. Please let me know.

Thanks,
Mike

 

[Frank Kabel]

Hi Mike
have a look at the SUMIF function in the Excel help. e.g.
=SUMIF(A1:A100,"condition",B1:B100)

 

[Mike Waters]

Thanks for the reply. I'll have to try that function
then. I'm not totally sure how I would need to wrtie the
funtion though. What I would want to do is say, add
everything in the range C1:C1000 if cell A?(the one that
would corispond to the C being added) equals "R". Or a
sum of the range where the A column equals "C". Would
something like =sumif(A1:A1000,"R",C1:C1000) work. I'm
just guessing on what the corrent syntax for this.

Thanks,
MIke

 

[Frank Kabel]

Hi Mike
you guessed right