The formula works in Excel but in Calc it’s giving sporadic results - which indicates to me the syntax isn’t completely incorrect.
I have the profile formula set to Excel A1.
Cells A1:A15 contain the names of 15 different sheets I’m wanting to search and total the amounts.
Cell A19 contains the value to search each sheet. The values being search are in A2:A33 on each sheet and the amounts being added in each sheet are in D2:D33.
I’m not getting any errors and I haven’t been able to determine a pattern in the results but some results are coming from different sheets but none are totaling from multiple sheets. I initially thought there could be an issue with the cells being different formats so it wasn’t finding the values but all appear to be the same.
Any suggestions would be appreciated.