Feb 03 2022 06:44 PM
Hello helpful people
I have a large spreadsheet which converts raw transactional data into a Pivot table to summarise the total value of transactions on a monthly basis (B to J). I want to use the pivot table data to then populate the adjacent table in columns L to U to show the accumulated total in the month but only when the total is $750 or more. Using the below as an example I am trying to get the following to work automatically using nested IF functions:
Row 2
As B2 < $750 display 0 at M2. If however B2 was >= $750 display B2
As M2 = 0 and B2+C2 < $750 display 0 at N2. If however B2 + C2 >=$750 display result of B2+C2
As N2 = 0 and B2:D2 >= $750 display result of B2:D2 in O2 etc
Essentially once the threshold of $750 is met, I need it to restart the test.
Thanks