Excel "Sumif" Formula Equivalent

Reece

Forums

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.

Brian Element Mon, 03/14/2022 - 09:48

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.

Reece Mon, 03/14/2022 - 12:35

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.

Brian Element Mon, 03/14/2022 - 14:04

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.