Hi all,
I was wondering if there's a function or script that's similar to the "Sumif" formula in Excel? I'm trying to eliminate expense reversals and in Excel, I use the following sumif formula to achieve this:
=IF(SUMIF($BA:$BA,$BA2,$AU:$AU)=0,"Yes","No")
Where column BA is the unique expense number (which can be the same if there's a reversal of expense) and column AU is the expense amount.
Reece
Offline
Last seen: 1 year 10 months ago
Joined: 02/06/2020 - 07:18
Hi Reece,
You can't do this directly as IDEA really only looks at transactions by row. You could probably get the same results as doing a summary on your criteria and looking for items that are not 0 (they were not reveresed) and then adding them together.
Hi Brian,
Thanks for your quick reply! I was trying to work out what you mean by "doing a summary and looking for items that are not 0 and then adding them together" but I'm arfraid I couldn't quite understand. If you find the time, I'd apprecaite it if you could expalin it some more.
Any chance you can share an example file of what you are trying to do. Maybe I will be of more help if I have some data to look at and understand what you are trying to accomplish.