Sum Multiple Columns Alternate Rows on Condition Basis
Hi All,
Not able to do it with any formula, please help me with the attached file
in Sheet1 i have numbers for my analysts Date Wise
and in Sheet 2 there is a total for analyst date wise
For Example in Sheet there are 10 Categories i want to add on 02/01/2021 A touched how many task in all the categories and the total for 02/01/2021 for A should appear in sheett under 02/01/2021.
Your help is appreciated
Thank You
Sachin
Last edited by sg2209; 03-04-2021 at 10:09 AM. Reason: Could not see the attachment, Reattached
One way, in C2, copied across and down:
=SUMPRODUCT((Sheet1!$A$2:$A$50=Sheet2!C$1)*(Sheet1!$B$1:$AI$1=Sheet2!$A2),Sheet1!B2:AI50)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thank You so mucg for the response Glen , Appreciate you , checked theattached file , seems that some numbers are getting repeated in sheet 265416, 88504, 88490 etc how these is getting caulated not sure , and total are absolutely incorrect due to this if you see Total f A in Sheet 1 is 338 in all 10 categories then the sum would be 3380 andin the resolution file you shared is 621970 a big difference.
i did freeze the ranges and removed Dates column , only Dates are there in Column A
Working Formula
=SUMPRODUCT((Sheet1!$A$2:$A$50=Sheet2!E$1)*(Sheet1!$B$1:$AI$1=Sheet2!$A6),Sheet1!$B$2:$AI$50)
Thank You so very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks