Hi Excel gurus,
Can you please help me to bring the attached excel sheet condition. I need to compare sheet 1, product_id and product_name with 2nd sheet and do calculation for below columns
tran_leesthan_0 =COUNTIF(Sheet2!D2:D8,"<0")
Sales_less than_0 =SUMIF(Sheet2!D2:D8,"<0")
qty_lessthan_0 =SUMIF(Sheet2!E2:E8,"<0")
Please help me to bring the comparison between 2 sheets and do calculation.
Thanks in advance!!
excel question.xlsx
in Sheet3!F2
=COUNTIFS(Sheet2!B$2:B$23,B2,Sheet2!D$2:D$23,"<0")
in Sheet3!D2
=SUMIFS(Sheet2!D$2:D$23,Sheet2!B$2:B$23,B2,Sheet2!D$2:D$23,"<0")
in Sheet3!E2
=SUMIFS(Sheet2!E$2:E$23,Sheet2!B$2:B$23,B2,Sheet2!E$2:E$23,"<0")
copy down the columns
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks