Notifications
Clear all
General Excel Questions & Answers
5
Posts
2
Users
0
Reactions
67
Views
Topic starter
the summary example is paul
see attached
if i filtered date, the summary result for the paul should change as well.. please help
Posted : 14/07/2020 2:26 pm
Hi,
You need to add the date to the SUMIFS criteria. It can't just infer it from rows that are filtered out. I suggest you add the date you want the summary data returned for to a cell in column E, then you can reference it in the SUMIFS.
Mynda
Posted : 14/07/2020 7:30 pm
Topic starter
please can you give your answer in the excel and re-attach to me
Posted : 14/07/2020 7:32 pm
See attached.
Posted : 14/07/2020 10:27 pm
Topic starter
thanks for the attachment and the idea input. i think this is good answer. i will try organize the excel now.
thanks again
Posted : 14/07/2020 10:48 pm
