# Missing parenthesis

#### markdoughty

##### Board Regular
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

### Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
a bracket ) at the end of the formula ?

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.

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>

Last edited:
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)?

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.......

Replies
1
Views
287
Replies
3
Views
2K
Replies
12
Views
723
Replies
10
Views
1K
Replies
11
Views
519

1,203,027
Messages
6,053,120
Members
444,640
Latest member
Dramonzo

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back