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...
=SUMIF('data PY'!A:A,A4,'data PY'!E:E)Hope this works.
=IF(F$2="A",SUMIFS('2023 Actuals'!$E:$E,'2023 Actuals'!$D:$D,F$3,'2023 Actuals'!$A:$A,$A4),IF(F$2="B",SUMIFS('2023 Budget'!$E:$E,'2023 Budget'!$D:$D,F$3,'2023 Budget'!$A:$A,$A$4),""))
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.