Morning all
I was hoping someone could help me with the follow problem I have;
Below is the spreadsheet I am working on and the object of the calculation is to SUM column E and Column F based on the value(s) in Colum D The Name (Destination) and put the answer in L3 then L4 then L5 as the dates increase so the next row would be the 02/01/2021 etc.,
The value in L4 works fine it does indeed sum up all of the values if the text is Coral
However if I add £100 to Bet 365 the it goes onto the Coral overall value rather than to Bet 365 M(3)
This is the formula I've used in L3
=IF(VLOOKUP(L3,$D$4:$D$6000,1,TRUE)="Coral",SUMIF($A$4:$A$6000,K4,$E$4:$E$6000)-SUMIF($A4:$A6000,K4,$F$4:$F$6000),0)
and in M4
=IF(VLOOKUP(M3,$D$4:$D$6000,1,TRUE)="Bet 365",SUMIF($A$4:$A$6000,M4,$E$4:$E$6000)-SUMIF($A4:$A6000,M4,$F$4:$F$6000),0)
I realise the answer is correct according to the formula as the TRUE says if Coral Sum the column and Coral does exist in the Colum, however I want it to be selective, so if it's Coral do only coral values and if it's Bet 365 etc only do those values. There will be a lot more but for now just those two
Any ideas?
many thanks
Paul
I was hoping someone could help me with the follow problem I have;
Below is the spreadsheet I am working on and the object of the calculation is to SUM column E and Column F based on the value(s) in Colum D The Name (Destination) and put the answer in L3 then L4 then L5 as the dates increase so the next row would be the 02/01/2021 etc.,
The value in L4 works fine it does indeed sum up all of the values if the text is Coral
However if I add £100 to Bet 365 the it goes onto the Coral overall value rather than to Bet 365 M(3)
This is the formula I've used in L3
=IF(VLOOKUP(L3,$D$4:$D$6000,1,TRUE)="Coral",SUMIF($A$4:$A$6000,K4,$E$4:$E$6000)-SUMIF($A4:$A6000,K4,$F$4:$F$6000),0)
and in M4
=IF(VLOOKUP(M3,$D$4:$D$6000,1,TRUE)="Bet 365",SUMIF($A$4:$A$6000,M4,$E$4:$E$6000)-SUMIF($A4:$A6000,M4,$F$4:$F$6000),0)
I realise the answer is correct according to the formula as the TRUE says if Coral Sum the column and Coral does exist in the Colum, however I want it to be selective, so if it's Coral do only coral values and if it's Bet 365 etc only do those values. There will be a lot more but for now just those two
Any ideas?
many thanks
Paul