formulas only work in half of the rows

downtown · Apr 30th, 2002, 03:13 PM

I have a*spread sheet that takes entries in columns headed A and B and does addition and subtraction with the data entered. I have 50 or more rows in some of the spread sheets and for some reason, the formulas only work down to row 39. Data entered in rows 40 and above has no effect. All cells above row 40 (1-39) are identical in their format. It's making me crazy. HELLLLPPPP.
Thanks

Jack in the UK · Apr 30th, 2002, 03:15 PM

As so small data i would copy top another sheet and try....

Paul B · Apr 30th, 2002, 03:16 PM

Whant formulas are you using?

downtown · Apr 30th, 2002, 03:42 PM

I using the formula =SUMIF('A':'B',PRODUCT,'Q1':'Q2') where A and B are the product ID"s (1 is modems, 2 is monitors, etc..) and Q1 and Q2 are the quanities sold for each product. I put the product ID in A and the number sold in Q1 and it sums them to the product catagory.

Chris Davison · May 1st, 2002, 12:51 PM

Quote:

On 2002-04-30 14:42, downtown wrote:
I using the formula =SUMIF('A':'B',PRODUCT,'Q1':'Q2') where A and B are the product ID"s (1 is modems, 2 is monitors, etc..) and Q1 and Q2 are the quanities sold for each product. I put the product ID in A and the number sold in Q1 and it sums them to the product catagory.

the =SUMIF syntax is as follows :

=SUMIF(range to interrogate,criterion,range to sum)

are you sure you're following that exactly ?

post your EXACT formula, not a shortcut...

Apr 30th, 2002, 03:15 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	As so small data i would copy top another sheet and try.... __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 30th, 2002, 03:13 PM	#1
downtown New Member Join Date: Apr 2002 Location: indiana Posts: 4	I have a*spread sheet that takes entries in columns headed A and B and does addition and subtraction with the data entered. I have 50 or more rows in some of the spread sheets and for some reason, the formulas only work down to row 39. Data entered in rows 40 and above has no effect. All cells above row 40 (1-39) are identical in their format. It's making me crazy. HELLLLPPPP. Thanks

Apr 30th, 2002, 03:16 PM	#3
Paul B Board Regular Join Date: Feb 2002 Location: Georgia USA Posts: 544	Whant formulas are you using?

Apr 30th, 2002, 03:42 PM	#4
downtown New Member Join Date: Apr 2002 Location: indiana Posts: 4	I using the formula =SUMIF('A':'B',PRODUCT,'Q1':'Q2') where A and B are the product ID"s (1 is modems, 2 is monitors, etc..) and Q1 and Q2 are the quanities sold for each product. I put the product ID in A and the number sold in Q1 and it sums them to the product catagory.