Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Thursday, 18 January 2018
  0 Replies
  2.5K Visits
0
Votes
Undo
Hi ,

I have two sheets(Sheet1 & Sheet2), Sheet1 has all the formulas and displaying the results in the form of count. Most of the formulas I am using is SUM(COUNGIF,FILTER,...) as given below. I have a requirement that if I click on any of the count then it should take me to the Sheet2 and should display only the count which I clicked on. If I click on 5 then it should take me to Sheet2 and should display only 5 records which satisfies the below filter condition.

The formula I am using is =SUM(COUNTIFS(Sheet2!$U:$U,{"<>Conversion"},Sheet2!$E:$E,{"Approved"},Sheet2!$F:$F,{"Y - Initial PRICEFW"}, Sheet2!$Y:$Y,{"Capgemini"},Sheet2!$G:$G,{"2 - FSD In-Progress";"7 - FSD Passed Back or FSD Rejected"}))

Can you please help me to resolve my issue.

Thanks ,
Puru
There are no replies made for this post yet.