G
Gearoid
Guest
I've got a spreadsheet for totaling bets. There are two sheets:
Sheet 1 = Profit & Loss
Sheet 2 = Turnover Breakdown
Sheet 2 lists a number of bets and I want to break them down by meeting. I use the belwo formula.
=SUMIF('Turnover Brekdown'!A:A,'profit and loss'!B97,'Turnover Brekdown'!E:E)
This seems to work fine but for some reasons it does not 'read' a couple of bets so instead of totaling 1,000 in turnover for a meeting it will only total 950. It makes no difference when I change fonts etc. What am I doing wrong? I have no problem when running the same formula to total the months etc
Sheet 1 = Profit & Loss
Sheet 2 = Turnover Breakdown
Sheet 2 lists a number of bets and I want to break them down by meeting. I use the belwo formula.
=SUMIF('Turnover Brekdown'!A:A,'profit and loss'!B97,'Turnover Brekdown'!E:E)
This seems to work fine but for some reasons it does not 'read' a couple of bets so instead of totaling 1,000 in turnover for a meeting it will only total 950. It makes no difference when I change fonts etc. What am I doing wrong? I have no problem when running the same formula to total the months etc