How can we write a formula that we can look up the RIGHT tax type amount to put in the CORRECT company?
Please refer to the attachemnt
How can we write a formula that we can look up the RIGHT tax type amount to put in the CORRECT company?
Please refer to the attachemnt
try in C2
-confirmed with ctrl+shift+enter then fill down.Formula:Please Login or Register to view this content.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
you have to hit
ctrl+shift+enter ---not just enter it's an array formula youl'll notice the formula will be enclosed with curly braces { }when done right.
or
=SUMPRODUCT(--($K$2:$K$17=B2),--($J$2:$J$17=A2),$L$2:$L$17)
regards,
vladimir
Last edited by vlady; 01-11-2013 at 03:05 AM.
Hi,
As rightly suggested by vladimir, you can certenly use index/match or sumproduct.
I think the other alternative would be:
=SUMIFS($L$2:$L$17,$J$2:$J$17,$A2,$K$2:$K$17,$B2)
Available in exel 2007 and later
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks