Recent content by razaas

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)...