Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
40
Views
Topic starter
Hi All,
Need to update the value in cell C4 based on the invoices listed in cells F4:F20, which are merged in the criteria cell. Could you please assist me with the formula or update the value accordingly
Posted : 16/06/2025 4:51 pm
If I remember correctly you are using E2019. Then you are bound to use some helper columns that determine the 'group number' for each invoice. Then you can use SUMIF based on these group numbers.
Alternatively, use Power Query for something like this. Both solutions have been added to the attached file.
Posted : 16/06/2025 5:20 pm
