Thanks for that. whatever I could understand so far, you are trying to compare total amount in column AB with BE (for sheet 'Savings'). If so, Try this formula to check whether col AB is less than BE or not:-
*=IF((SUMPRODUCT($AF3:$AQ3=TRUE)*$AE3)>(SUMPRODUCT($C3:$N3=TRUE)*$B3);"Price Increased";"No Change")* In case you want to add both the columns AB and AE, Try this:- *=$B3*SUMPRODUCT($C3:$N3=TRUE)+SUMPRODUCT($AF3:$AQ3=TRUE)*$AE3* On Tuesday, April 5, 2022 at 5:10:05 PM UTC+5:30 alexk...@gmail.com wrote: > done: > > > https://docs.google.com/spreadsheets/d/1HouHgA885kCGZxpQ3sOWOfJL7scxvvp_INlJEIi8nto/edit?usp=sharing > > > Op dinsdag 5 april 2022 om 12:37:29 UTC+2 schreef parame...@gmail.com: > >> It would be helpful to understand the requirement If you could share the >> sample spreadsheet. >> >> On Tuesday, April 5, 2022 at 3:39:08 PM UTC+5:30 alexk...@gmail.com >> wrote: >> >>> If you wish, I could share the document with you. Just let me know. :) >>> Op dinsdag 5 april 2022 om 12:04:11 UTC+2 schreef Alex Kikkert - Home: >>> >>>> On page two, the overview behind the months: Jan to July should be € >>>> 60.00 and behind Aug to Dec: € 75.00. After the formula has checked >>>> whether >>>> there has been a price increase (AB2) for a certain month (AE2:AP2) >>>> >>>> Op maandag 4 april 2022 om 17:53:12 UTC+2 schreef parame...@gmail.com: >>>> >>>>> Hi, >>>>> >>>>> What should be output for the given sample? >>>>> >>>>> On Sunday, April 3, 2022 at 3:05:46 PM UTC+5:30 alexk...@gmail.com >>>>> wrote: >>>>> >>>>>> I'm working on a small cash book. I'm looking for a formula that >>>>>> compares two rows of checkboxes. >>>>>> On the left you see a magazine subscription of 60 euros per month, on >>>>>> the right the subscription has been increased to 75 euros per month from >>>>>> August. >>>>>> the months are in the red colored row. >>>>>> >>>>>> [image: 111.png] >>>>>> The formula I am looking for must first check whether the month has >>>>>> been checked off, the monthly subscription has increased (or decreased) >>>>>> in >>>>>> price and then this new, adjusted amount (column B and AD) must be >>>>>> chosen / >>>>>> displayed. >>>>>> >>>>>> I hope I have been able to clarify my personal search for a good >>>>>> formula a bit. >>>>>> Sorry for my poor English, luckily there is Google translation ;) >>>>>> >>>>>> Kind regards, >>>>>> Alex >>>>>> >>>>> -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-spreadsheets-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/google-spreadsheets-api/72ea5241-d35f-4399-96c7-8cea8c767676n%40googlegroups.com.
