Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Cell Names
Hi. What I'm trying to do is use cell names for formulas...for
example. I have a worksheet that has total sales for each month and total revenue. Jan Socks 2.00 Revenue 10.00 Hats 5.00 Socks 2.00 Revenue 30.00 Total Sales = socks + hats + socks Total Revenue = revenue + revenue Total = revenue + sales Feb Hats Mitts Revenue Socks Hats Total Sales = hats + mitts + socks + hats Total Revenue = revenue Total = revenue + sales I would like name all the socks cells as "socks" and all the revenue cells as "revenue" and then use it to calculate each moths totals. But what happens if I name the 1st socks cell and then make the 2nd one = socks, then in the total it doesn't add them together, it only uses the first amount. Any ideas? Thanks, Cathy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Cell Names
Cathy,
Forget names, since you can't use duplicate names. Try =SUMIF(A:A,"Socks",B:B) =SUMIF(A:A,"Revenue",B:B) Better yet would be a database: Date Item Amount Feed that to a pivot table... HTH, Bernie MS Excel MVP wrote in message ... Hi. What I'm trying to do is use cell names for formulas...for example. I have a worksheet that has total sales for each month and total revenue. Jan Socks 2.00 Revenue 10.00 Hats 5.00 Socks 2.00 Revenue 30.00 Total Sales = socks + hats + socks Total Revenue = revenue + revenue Total = revenue + sales Feb Hats Mitts Revenue Socks Hats Total Sales = hats + mitts + socks + hats Total Revenue = revenue Total = revenue + sales I would like name all the socks cells as "socks" and all the revenue cells as "revenue" and then use it to calculate each moths totals. But what happens if I name the 1st socks cell and then make the 2nd one = socks, then in the total it doesn't add them together, it only uses the first amount. Any ideas? Thanks, Cathy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell names | Excel Discussion (Misc queries) | |||
Cell names = sheet names | Excel Worksheet Functions | |||
difference between cell names and cell labels | Excel Discussion (Misc queries) | |||
How to create table of cell names with the name's cell address | Excel Discussion (Misc queries) | |||
Cell names | Excel Discussion (Misc queries) |