Notifications
Clear all
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
Topic starter
Hi Riny
yes i am using 2019 and awesome its working fine and thanks for your help
Posted : 17/06/2025 1:47 pm
