Forum Discussion

KOTTARATHIL's avatar
KOTTARATHIL
Copper Contributor
Jul 20, 2022

help for formulae

need help to make a report sheet from data entry sheet. please see the attached screen shots. the numbers in cell of data entry are manually added. i want the same numbers automatically updated in "d...
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Jul 20, 2022

    KOTTARATHIL In S4 on the Dues sheet, use this:

    =FILTER(Data_Entry!$H:$H,(Data_Entry!$F:$F=$R4)*(Data_Entry!$I:$I=S$3),"-")

    But you also need to use text headings on row 4 that exactly match the ones used in column I of the Data sheet. Lastly, one entry for 3E is in March 2022. The list item in the dropdown is a real date. change that to a text as well "Mar-22".

    Made these changes in the attached file.

Harun24HR's avatar
Harun24HR
Bronze Contributor
I assume you need XLOOKUP() function. Can you please attach a sample file so that we can work on that. Also explain little more which data do you want to show on "Dues from owners" sheet. Do you want only show data from data entry sheet or want to sum or count data?
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Jul 20, 2022

    KOTTARATHIL In S4 on the Dues sheet, use this:

    =FILTER(Data_Entry!$H:$H,(Data_Entry!$F:$F=$R4)*(Data_Entry!$I:$I=S$3),"-")

    But you also need to use text headings on row 4 that exactly match the ones used in column I of the Data sheet. Lastly, one entry for 3E is in March 2022. The list item in the dropdown is a real date. change that to a text as well "Mar-22".

    Made these changes in the attached file.

    • KOTTARATHIL's avatar
      KOTTARATHIL
      Copper Contributor
      Jul 20, 2022
      GREAT, THANK YOU VERY MUCH

Resources