Forum Discussion
Solved
Help with Countif & Match formula
Hi All, I have a spreadsheet which includes an account name, a column for the fee type and the balance held for each month. I am looking to do some reporting on the number of funds on each fee ty...
calof1 See attached. Perhaps not the prettiest way, but it seems to work.
=SUM((INDEX($A$2:$H$11,0,MATCH(K2,$A$1:$H$1,0))<>0)*($B$2:$B$11=$J$1))where $J$1 in the end is an absolute reference to a cell where you enter the fee type.
Note that I also change the dates in the summary table to the dates used in the header of the fund table.
calof1 See attached. Perhaps not the prettiest way, but it seems to work.
=SUM((INDEX($A$2:$H$11,0,MATCH(K2,$A$1:$H$1,0))<>0)*($B$2:$B$11=$J$1))
where $J$1 in the end is an absolute reference to a cell where you enter the fee type.
Note that I also change the dates in the summary table to the dates used in the header of the fund table.
Hi Riny_van_Eekelen,
Thank you kindly for your assistance, very much appreciated.
Kind regards,
Thank you kindly for your assistance, very much appreciated.
Kind regards,