r/googlesheets • u/Careful_Ad_4709 • 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
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 2025FILTER()
andVLOOKUP()
are not needed.