View Single Post
 
Old 04-30-2018, 01:28 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

The formulas will be easier to write, easier to read, and will added automatically to new records (so long as the formula in column remains same), when you define both of your tables as Tables (Insert > Table, and give a meaningful name e.g. tSource and tTarget). NB! All columns in Table must have headers, so add header Area to second table too. And avoid apostrophes (and as best spaces too) in headers - like FathersName vs. FATHER's NAME.

Now select any cell in column TestScore (e.g. T2), and enter the formula
If TestScore in tSource is numeric
Code:
=SUMIFS(tSource[TestScore],tSource[StudentName],[@Name],tSource[FarhersName],[@FarhersName],tSource[Domicile],[@Domicile])
If TestScore is string, then convert it to number, or add field SNumber to 2nd table too and use VLOOKUP function:
Code:
=VLOOKUP([@SNumber],tSource, 7, 0)
Reply With Quote