On "Source Data Sheet", There is Day by Day sale for each company.
On Entry Sheet, I want to pool data as per Date mentioned in B2 Cell. Whenever I will change Date in B2 then data for newly entered Date will come in front of Company Name.
Same way Highest sale and Lowest sale for each company for specific month I mentioned in Reference Cell i.e. D2:E2
Same way I want Data for Specific Week and reference cell G2:H2 is having Week Reference Dates
Attached excel sheet is having more explanation.
I had to change one of the dates to a real date 2022 not 20222
i have used
SUMIFS()
=SUMIFS('Source Data Sheet'!$C$2:$C$161,'Source Data Sheet'!$A$2:$A$161,'Entry Sheet'!A4,'Source Data Sheet'!$B$2:$B$161,'Entry Sheet'!B$2)
MAXIFS()
=MAXIFS('Source Data Sheet'!$C$2:$C$161,'Source Data Sheet'!$A$2:$A$161,'Entry Sheet'!A4,'Source Data Sheet'!$B$2:$B$161,">="&'Entry Sheet'!D$2,'Source Data Sheet'!$B$2:$B$161,"<="&'Entry Sheet'!E$2)
=MAXIFS('Source Data Sheet'!$C$2:$C$161,'Source Data Sheet'!$A$2:$A$161,'Entry Sheet'!A4,'Source Data Sheet'!$B$2:$B$161,">="&'Entry Sheet'!G$2,'Source Data Sheet'!$B$2:$B$161,"<="&'Entry Sheet'!H$2)
MINIFS()
=MINIFS('Source Data Sheet'!$C$2:$C$161,'Source Data Sheet'!$A$2:$A$161,'Entry Sheet'!A4,'Source Data Sheet'!$B$2:$B$161,">="&'Entry Sheet'!D$2,'Source Data Sheet'!$B$2:$B$161,"<="&'Entry Sheet'!E$2)
=MINIFS('Source Data Sheet'!$C$2:$C$161,'Source Data Sheet'!$A$2:$A$161,'Entry Sheet'!A4,'Source Data Sheet'!$B$2:$B$161,">="&'Entry Sheet'!G$2,'Source Data Sheet'!$B$2:$B$161,"<="&'Entry Sheet'!H$2)
spreadsheet attached -
BUT i will just recheck the results, as not happy with the MIN of zero
edit - OK , row 62 has zero 0 for HINDALCO, so did not see that - and then filtered - so ALL OK
Last edited by etaf; 04-02-2022 at 10:37 AM.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi ETAF,
Thanks for the reply. Your formula worked for me and I really thanks for timely Help. Even I am sorry for not replying on Time due to some health issue.
you are welcome
sorry to hear you have health issues, hope you get well soon
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks