Boards
Excellent question
i'm having to rewrite a spreasheet so that our client (who is living in the fucking dark ages) can use it. anyway, as their pivot tables aren't strong enough i need to do this. when i use the fx checker thing, the value comes out corretly, but the cell displays zero. does anyone have any ideas?
=IF(AND($B$7="All",$B11="Grand Total",OR($F$2="True",$F$7="All")),COUNT(Export_Data!$A:$A),SUMPRODUCT((IF($B$7="All",1,(Export_Data!J:J=$B$7)))*(IF($B11="Grand Total",1,(Export_Data!E:E=$B11)))*(IF(OR($F$2="True",$F$7="All"),1,(Export_Data!AM:AM=DATE(YEAR($F$7),MONTH($F$7),DAY($F$7)))))))