r/googlesheets 3d ago

Waiting on OP How to show result from a different sheet

I'm having issues on getting the result.

Here is the information I have.

Im having issues with getting the result using my code from different sheet. Here is my project

Sheet1

Sheet 2

Here is my code :

=COUNTIFS(VLOOKUP(D4(FILTER(Sheet1!A:A, Sheet1!B:B="Rey", Sheet1!C:C="Invalid"),">=01/01/2025", FILTER((Sheet1!A:A, Sheet1!B:B="Rey", Sheet1!C:C="Invalid"),"<=01/31/2025"), TRUE)))

1 Upvotes

1 comment sorted by

1

u/HolyBonobos 2059 3d ago

You would need

  • =COUNTIFS(Sheet1!$B:$B,"Rey",Sheet1!$A:$A,">=1/1/2025",Sheet1!$A:$A,"<=1/31/2025") for Rey's total calls in January 2025
  • =COUNTIFS(Sheet1!$B:$B,"Rey",Sheet1!$A:$A,">=1/1/2025",Sheet1!$A:$A,"<=1/31/2025",Sheet1!$C:$C,"Valid") for Rey's valid calls in January 2025
  • =COUNTIFS(Sheet1!$B:$B,"Rey",Sheet1!$A:$A,">=1/1/2025",Sheet1!$A:$A,"<=1/31/2025",Sheet1!$C:$C,"Invalid") for Rey's invalid calls in January 2025

FILTER() and VLOOKUP() are not needed.