Hi, could someone please take a look at the following formula and if they can sport the parse error. It was working but now doesn't and I haven't changed anything:
Please Login or Register to view this content.
Hi, could someone please take a look at the following formula and if they can sport the parse error. It was working but now doesn't and I haven't changed anything:
Please Login or Register to view this content.
Why do you have the = signs? For example, this:
=SUMIFs(amounts,trans,"=Deposit",currency,"=ETN")
should be this:
=SUMIFs(amounts,trans,"Deposit",currency,"ETN")
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi AligW, that's because I seen it in a tutorial lol
I have removed them but still have a "formula parse error"
Hmm it wasn't liking the named ranges. I switched to selecting a cell range and it works now.
If that is the case, it is possible that the named ranges were not of the same dimensions (e.g. one could have been 10 rows while the other was 11 rows).
A SUMIFS formula requires that all of the ranges be the same dimension.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks