Search results

Thanks a lot, it works perfectly. Highly appreciate.

Yes!

Thanks for the reply, no it is not working, it returns same result with EOMONTH also, sums together each month from different years, such as Nov. 2022 and 2023 together and so on.

Yes last occurrence of each end of month date, including year, should have end of month total for that particular month and year. Thanks

Yes I checked it, it is working but require to drag down the formula from cell above, if only the cell value changed it won't update automatically. Thanks for follow up.

Yes it is working perfectly, thanks a lot and very sorry I didn't check it properly earlier. Thanks

#5 and #7 both are clear about what I need, anyway no issues, I didn't mean to discredit your solution, though it is not what I need but I am really ok with it and can close the thread as solved. Thanks

Yes I did, please refer #7.

Thanks for the reply, I thought my explanation was clear enough with the sample and 'pecoflyer' got it right. I was looking for the result to be within the same table not as a pivot table, anyway no problem thanks once again.

Thanks for the reply, but your formula checking only month, if the year changes then it is not matching the date, could you please provide solution by evaluating the full date including year.

Thanks for the reply, sample file attached, I want the result (total) at end of month but at the last occurrence of each end of month date, not repeated as many times as the date repeated.

Thanks for reply, I have more than one 'end of month' dates in a column, I want end of month total only once at the last occurrence of end of month.

Hi, I am trying use the below formula but it is returning #Ref! error, when I try SUMIFS separately and SUMPRODUCT separately they both returns correct result and also the complete formula with F9 showing the correct values. INDEX(SUMIFS('Daily Income Record'!$C$4:$C$1514, 'Daily Income...

Thanks a lot, without header and with header both works, great help, highly appreciate. Thanks

Hi, with the below formula I get a spilled range in 2 columns and 3 rows, I want to get total of the 3 values in 4th row, as example below. Thanks Col A Col B AAA 123 BBB 234 CCC 345 Total 702 =LET(pm,SORT(UNIQUE(Table3[Payment Mode]),1,1)...

Thanks a lot, it works.

Thanks for the suggestion, I had already done that but was expecting to find solution to spill thru 1 formula, I will wait for more replies and possibly a solution. Thanks

Thanks a lot for the reply, my version of Excel does not have VSTACK Function, any other option? Thanks

Hi, Below formula is working fine and spills result as desired, I want help to add a headings row in the top row of the spill range, my spill range has 3 columns, I want to have "Value1", "Value2","Value3" as column names. Thanks =LET(end_of_month_dates1, EOMONTH(--Table3[Date], 0)...

You have not given any formula for 3rd row. Because I am not expert like you. I knew my solution might not be perfect that is the reason I asked for your comments and suggestions, you gave only comments but no suggestions. Highly appreciate your comments, your formulas for first two rows...

Hi Narayan, Don't be so arrogant please, I did not ask you for another formula, appreciating your super skills I just asked your comments and suggestions on the formula in the attached file, few of my comments which I think you ignored what I meant was for all cells in each row which I...

Hi Narayan, I think you didn't read my previous reply and not checked the attached file. Thanks

Hi Narayan, Thanks a lot, it works well, but you missed the 3rd highlighted row, in the mean time i tried myself and succeeded with very long IF formula and first row with hard coded numbers, i wanted one formula for all cells, sample attached for your comments and suggestions. Please check...

Thanks a lot NarayanK991 for looking into my query, yes the number of columns will be 8 only, max input value cell K5 can be 2500 and all other Qs "yes" you guessed them correctly. Thanks, Raza

Please help with 3 formulas to auto populate the numbers, sample highlighted in yellow, in the attached excel file. Cell K5 is the input number, based on K5 all yellow highlighted cells shall auto populate in the pattern shown in Table 1 and if the assigned formulas working fine then the result...