Forum Discussion
If formula
Alternative
= LET( s, BYROW(data, LAMBDA(d, MAX(SUM(d), 0))), VSTACK(s, SUM(s)) )
Yousef70 Add to which formula?
this one =SUMIF(M6:N6,">=0",M6:N6)
- Dear Hans...
Noted Forums such as this one, Microsoft Community and others are intended to help people on their way, not to create complete solutions for them.
If you make a start yourself and run into a specific problem, you are very welcome to post a question about it here. But if you want a complete solution, you should hire a professional developer.
- Dear Riny
I understand , can you direct me where to go ?
Thanks Yousef70 Sorry, but that kind of work goes beyond the scope of my involvement in this forum
Dear Riny...
Kindly , looking for your help in developing attached excel sheet further , I will elaborate on what is needed :-
First , I have started this sheet many years ago with two parts in it ( it is as a daily excel calendar ) :-
- Upper part is for my business ( calculating break even point on profit margin provision )
- Lower part is personal ( income distribution based on % of each expense to total expenses )
Second , profit margin provision is entered manually at day one of each month based on last month average
Third , weekends take half the daily cost ( sales are usually lower on weekends ) where weekdays take full cost + difference from weekends
Fourth , total sales needed to break even with cost is calculated based upon profit margin which is divided to weekdays and weekends accordingly
Fifth, I need to automate few things in this sheet :-
- Need to have profit margin average automated on daily basses ( when data is entered ) . daily profit is at line 11 starts at cell T
- Need to have all cells with profit margin update to daily average accordingly , for example cells C37 , J20 , K20 , etc.
- Lost sales to break even point starts at line 12 cell T ( based on provision ) , need a formula at cell K20 to add lost sales daily after dividing it to remaining weekdays , same at cell P20 for weekends ( keeping in mind profit margin average ) , Also , if sales exceed the break even point , the formula will subtract from remaining weekdays for cell K20 and weekends for cell P20.
This it for know , we will fine tune accordingly
Thanks in advance
- THANKS A MILLION FOR YOUR INPUT
IT SEEMS THAT MY NEEDS ARE COMPLICATED Yousef70 I don't see anything like "honored", "not honored" or "not due". I have no clue what you are talking about. Sorry.
Dear Riny …
Attached excel accounting calendar that I managed to create according to my knowledge
please , open August sheet look at columns M ( checks ) and N ( taxes ) both are post dated "not due" yet , once Due , it is either "honored" it will in positive numbers or "not honored" it will be in negative numbers where your formula will work to only add positive numbers but not "not due" cells as per not determined yet whether "honored" or "not honored".
thanks in advance
Yousef70 Sorry, don't understand. Can you upload/share a file clearly showing your intentions?
