200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Hi,
I am trying to practice the sumifs function on certain data. I need to calculate the Profit from one of table (Table-B) by using the SUMIFS function. The table contains Date, region, Sales Rep, Customer, product, COGS & Sales. I need to calculate Profit(Sales-COGS) without creating an additional column Profit in Table B.
I have attached the file & highlighted (in yellow) the section in which result is to be displayed. Can you help me out in the calculation?
Try this formula:
=SUMIFS(V5:V2003,T5:T2003,I27,Q5:Q2003,J26)-sumifs(U5:U2003,T5:T2003,I27,Q5:Q2003,J26)This should work for cell J27 and you can update it from there to work with the other cells.
(on a side note, you really need to learn this and not just have someone else do your homework for you... this is basic stuff!!!)