Hi All,
i want to calculate total sales amount in the year 2015 by using the condition. please check the attached workbook.
Hi All,
i want to calculate total sales amount in the year 2015 by using the condition. please check the attached workbook.
A password is needed to open your file - what is it?
Pete
sorry, password is 1234
I would try it this way...
=SUMIFS('Sales Data1'!$I$3:$I$52,'Sales Data1'!$C$3:$C$52,Case1!B4,'Sales Data1'!$E$3:$E$52,2015)
key off the employee ID.
EDIT:
could even do it this way if all you want to do is change I3 from total sales 2015 to total sales 2016, then the formula will automatically update...
=SUMIFS('Sales Data1'!$I$3:$I$52,'Sales Data1'!$C$3:$C$52,Case1!B4,'Sales Data1'!$E$3:$E$52,RIGHT($I$3,4))
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
You can use this formula in cell I4 of the Case1 sheet:
=SUMIFS('Sales Data1'!I:I,'Sales Data1'!C:C,B4,'Sales Data1'!E:E,2015)
then copy down.
Hope this helps.
Pete
Sorry, didn't notice the "salesperson" designation so instead...
=IF(E4="salesperson",SUMIFS('Sales Data1'!$I$3:$I$52,'Sales Data1'!$C$3:$C$52,Case1!B4,'Sales Data1'!$E$3:$E$52,RIGHT($I$3,4)),"")
OR
=IF(E4="salesperson",SUMIFS('Sales Data1'!$I$3:$I$52,'Sales Data1'!$C$3:$C$52,Case1!B4,'Sales Data1'!$E$3:$E$52,2015),"")
AND of course change your ranges as appropriate.
Last edited by Sam Capricci; 02-19-2019 at 07:41 AM.
Thanq All. its working. thanks for your help.
You're welcome! And if that takes care of your question don't forget to mark the post as solved using the thread tools dropdown at the top of the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks