Spreadsheet 1 - Sales by product.
I have a total of 5 products.
and by using SUM , i calculate the total sales of all product.
Spreadsheet 2 - Total sales by different branches.
How do i transfer the sum i have in spreadsheet 1 to 2 ?
Thanks !
Spreadsheet 1 - Sales by product.
I have a total of 5 products.
and by using SUM , i calculate the total sales of all product.
Spreadsheet 2 - Total sales by different branches.
How do i transfer the sum i have in spreadsheet 1 to 2 ?
Thanks !
Last edited by BlueLobster; 06-14-2010 at 11:59 AM.
Read up on the SUMIF() function.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
yeah , i read up on that alr . but i don't really know how to use that function .
SUM all the data in column B if column A matches a specific value? Sounds like it's exaclty what you're looking for.
http://www.techonthenet.com/excel/formulas/sumif.php
http://spreadsheets.about.com/od/exc...f-function.htm
http://support.microsoft.com/kb/275165/en-us
I don't know of an easy way to do what you wanted with that data layout, but I added the location names to each row to make an INDEX/MATCH still possible.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks