#### AndrewKent

##### Well-known Member

- Joined
- Jul 26, 2006

- Messages
- 889

Now I think this is what this particular function is called but I'm not 100% sure. I'm not talking about the "$" function more this example...

Code:

`{=SUM(IF('The Log'!$S$2:$S$675=$A$1,IF('The Log'!$B$2:$B$675='Retail Summary'!$E$1,IF('The Log'!$A$2:$A$675=$E$13,IF('The Log'!$J$2:$J$675=E16,1,0),0))))}`

...now this formula looks at a table of data and only SUM's each column IF a row meets a certain criteria. Now when I put the formula together it didn't work until I put the "{" and "}" around the whole thing. Then it worked perfectly. I manually checked the table and it has returned the correct values. How and why do I need "{" and "}" for this to work? I'm a complete novice so I have to ask questions!

Many many thanks,

Andy