Missing parenthesis

[markdoughty]

A quick one for the trained eye...

I keep getting the missing parenthesis error message. Have tried adding one in as many different places as i can think, but im clearly missing something.

=SUMIFS('Sheet1'!N:N<'Exported Data'!J:J,'Sheet1'!N:N-'Sheet1'!J:J,IF('Sheet1'!N:N>'Sheet1'!L:L,'Sheet1'!N:N-'Sheet1'!L:L,0)

Many Thanks

 

[salfordchameleon]

a bracket ) at the end of the formula ?

 

[Firefly2012]

Perhaps it would help if you explain what you intend your formula to do (ie what result you want from the data you have)? What you have is not going to be a valid SUMIFS no matter how many brackets you add.

 

[markdoughty]

Thanks for the response, in way of explanation:-

Im trying to formulate a calculation that works out the over / under valuE of stock holding by using min stock level / max stock levels and comparing them to actual stock held:-

Below is a snippet of the acual sheet which contains over 5000 rows.

J................... K............................ L................... M ........N........ O.....P............ Q

StockLevelMin	EnvironmentalStatus	StockLevelMax	QtySold	Actual	Avail	On Order	Cost
5.................	Non Wood Based	....................10	0	1	1	0	51.31
1.................	Non-Certified Wood Products............4	0	1	1	0	75.51
2.................	Non-Certified Wood Products............6	0	1	0	0	118.39
3.................	Non-Certified Wood Products............8	0	1	1	0	153
10................	Forest Stewardship Council.............20	2	1	1	0	16.65
25................	Non-Certified Wood Products..........40	0	1	1	0	71.35
5.................	Non-Certified Wood Products..........10	0	1	1	0	138.69
50................	Non Wood Based	.................100	0	1	1	0	43.98
1.................	Non Wood Based	....................5	0	1	1	0	22.6
15................	Non Wood Based	...................40	0	1	1	0	40.32
5.................	Non Wood Based	...................20	0	1	1	0	33.32
2.................	Non Wood Based	...................10	0	1	1	0	43.98

<tbody>
</tbody>

 

[Firefly2012]

OK that's a start but you need to explain given the example data above what result you expect given what parameters you intend to apply (eg so if looking exclusively at "Non Wood Based" what result are you expecting? How is that result to be obtained (ie what columns does it reply on and what criteria should be applied)?

 

[markdoughty]

PS, the calculation works fine when used on the same sheet just using the = (equals) sign then typing in formula. Its only when trying to action the calculation from sheet2 that a problem occurs, hence why i though a SUMIF or COUNT or something similar may be needed.......