I recently had responsibility of a spreadsheet passed down to me, and there's an array formula used that is labled "increase count". Here is the formula: {=SUM(IF(G89:G118>S89:S118,1,0))} Columns G and S have various dollar amounts for sales in them, so the actual sum of them is a very large number, the the formula is returning a much smaller number. I just want some help understanding what this formula is calculating, if possible.
Bookmarks