Countif/Countifs

[ArcticAce]

Hello, I am working with a workbook that was created by someone else and they have the following formula in cell I12: =COUNTIF(Table2[[#All],[4/25/2021]],$A12) The date 4/25/2021 is in Cell I1 (column header) I have tried to change the date to I1 but keep getting an error message. Is it possible to change this formula so that the date from I1 will return the date from sheet 2 with the same column header date. I need to make this formula work in several columns. Thanks in advance for any assistance that you can provide to me.

 

[Sufiyan97]

Hello, I am working with a workbook that was created by someone else and they have the following formula in cell I12: =COUNTIF(Table2[[#All],[4/25/2021]],$A12) The date 4/25/2021 is in Cell I1 (column header) I have tried to change the date to I1 but keep getting an error message. Is it possible to change this formula so that the date from I1 will return the date from sheet 2 with the same column header date. I need to make this formula work in several columns. Thanks in advance for any assistance that you can provide to me.

Please post some sample data with desired result using below link