Sorry to repost on this. I have set this up now using a Sharepoint List rather than an Excel Spreadsheet. The list is called Leave Request. I am trying to recreated the formula as well as adding something else to it but I can't seem to get this to calculate correctly.
SP List is Named 'Leave Request'
Columns involved are named 'Full Name', 'Status' , 'Leave Type' and 'Days' in the SP List
So I'm trying pull through from the SP LIst, the number of Days where Full Name = User, Status = Approved, Leave type = Holiday
The Filter formula used has a function in it (User()), which will cause a delegation issue if im not mistaken, for sharepoint that means it will only return 500 records, you can up this to 2000, however you're going to have a problem doing a sumifs if all the records are not returned.
One option is to try and send off the user name as a variable, but this is not going to get around the number of records returned.