Forum Discussion
SumIfs and Sum Products
I need help on a report that deals with sum ifs or sum products BUT I'm struggling to get it working. So if someone could take a look and PLEASE HELP me it would be very much appreciated. All the co...
=IF(F$2="A",SUMIFS('2023 Actuals'!$E:$E,'2023 Actuals'!$A:$A,Summary!$A4,'2023 Actuals'!$D:$D,CONCATENATE(LEFT(F$3,4),"/",RIGHT(F$3,3))),IF(F$2="B",SUMIFS('2023 Budget'!$E:$E,'2023 Budget'!$A:$A,Summary!$A4,'2023 Budget'!$D:$D,CONCATENATE(LEFT(F$3,4),"/",RIGHT(F$3,3))),""))This is my suggestion for cell F4. In order to compare the results i've entered the formula in cell F14 and filled it across range F14:Q19.
=SUMIFS('data PY'!E:E,'data PY'!A:A,Summary!A4,'data PY'!B:B,Summary!B4)You can try this formula in cell C4.
OliverScheurich I am SO sorry about not coming back to you earlier but I have been away for the summer. THANK YOU SO MUCH, that's brilliant and works a treat. I wish I could be able to do formula like this, your very talented. Thanks again.