Forum

I think this is what I was after: SUMPRODUCT( (GreenFeeIncome[Member Type]="member playing outside days - £20") * (TEXT(GreenFeeIncome[Date],"ddd")=Z...

It wouldn't be my choice either to work like this, but I haven't a lot of options. The table is for a golf club, and the management really like the w...

I have thought of Pivot Tables and I have some for this data, however I cannot seem to get the Pivot tables to do what I want to do for this workbook....

File now added