Excel formula - Microsoft Community

Ask a new question

Excel formula

My data contains "High evidence/confidence of contamination", "Low evidence/confidence of contamination" and "Insufficient evidence of contamination". I'm using function =COUNTIF(Table46[Overall Assessment],"High evidence/confidence of contamination") in data set. It's working. But when I'm filtering by "Reporting Date" and this data set not changes and it still shows the same result. how should I do?

|

D1: =SUMPRODUCT((SUBTOTAL(103,INDIRECT("A"&ROW(Table46[Overall Assessment])))=1)*(Table46[Overall Assessment] = "High evidence/confidence of contamination"))

Filtered:

If you need further help I need to see your (sample) file.
Why a sample file is important for troubleshooting. How to do it. - Microsoft Community

Andreas.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi,

In cell B13, enter this formula

=SUM((BYROW(A2:A7,LAMBDA(a,SUBTOTAL(103,a))))*(A2:A7=A13))

Hope this helps.

Regards,

Ashish Mathur
www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated May 10, 2024 Views 15 Applies to: