View Single Post
 
Old 01-09-2023, 04:34 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Much easier and more flexible way
Code:
=SUMIFS(Data!$D$2:$D$13,Data!$B2:$B13,Calculation!$B$1,Data!$A$2:$A$13,Calculation!$B$3)
Define fields Calculation!$B$1 and Calculation!$B$5 as Names, like nPFNo and nDate - the same formula will be
Code:
=SUMIFS(Data!$D$2:$D$13,Data!$B2:$B13,nPFNo,Data!$A$2:$A$13,nDate)
Define the Table on sheet Data as Defined Table, eg. tData, and the same formula will be
Code:
=SUMIFS(tData[Salary],tData[[PF No]],nPFNo,tData[Month],nDate)
Replace column header [PF No] in tData Table with PF, and check out the formula in Table syntax for Salary in Calculation Sheet - you see the formula was changed properly too!
Reply With Quote