Home |
Search |
Today's Posts |
#1
|
|||
|
|||
adding total business....how to?
I have 3 columns for each month...
column A name column B invoice number column C value (£s) Then column D,E,F for the next month and so on for 12 months In each month a name may appear several times and over the year quite a few times in the various months/columns. Is there an easy way to find out the value of a given Name and the total value for the year for that name? All the columns are on one sheet of a workbook. Thanks |
#2
|
|||
|
|||
=sumif(A1:AC2000,"Johnny",C1:AF2000)
assumes no invoice number will equal a Name. -- Regards, Tom Ogilvy "Juco" wrote in message . uk... I have 3 columns for each month... column A name column B invoice number column C value (£s) Then column D,E,F for the next month and so on for 12 months In each month a name may appear several times and over the year quite a few times in the various months/columns. Is there an easy way to find out the value of a given Name and the total value for the year for that name? All the columns are on one sheet of a workbook. Thanks |
#3
|
|||
|
|||
Mr. Ogilvy,
I have been searching for the same solution...somewhat. Could you please help me. On A1, I have an excel list - "Contries" (dropdown or list. On B1 another list with "Type of Shipping" also as a dropdown choice. On the C1 cell the result to autopopulate, according to the A1+B1 choices. (The lists for A1 and B1 are aquired from within the same worksheet) EXAMPLE. A1 "countries" = Italy, France, England. B1 "Types of Shipping" = Overnight $20.00, Two-Day $10.00, Snail $3.50 VALUES FOR THE B1 DEPENDING ON THE CHOICE OF A1 COUNTRY of destination.(Italy + Snail($3.50))= C1 $3.50 | For (England + Snail ($5.30)= C1 $5.30 I thank you in advance for any consideration on my quest. Janvier -- Message posted via http://www.officekb.com |
#4
|
|||
|
|||
thanks that worked a treat.
appreciated "Jay Villars via OfficeKB.com" wrote in message ... Mr. Ogilvy, I have been searching for the same solution...somewhat. Could you please help me. On A1, I have an excel list - "Contries" (dropdown or list. On B1 another list with "Type of Shipping" also as a dropdown choice. On the C1 cell the result to autopopulate, according to the A1+B1 choices. (The lists for A1 and B1 are aquired from within the same worksheet) EXAMPLE. A1 "countries" = Italy, France, England. B1 "Types of Shipping" = Overnight $20.00, Two-Day $10.00, Snail $3.50 VALUES FOR THE B1 DEPENDING ON THE CHOICE OF A1 COUNTRY of destination.(Italy + Snail($3.50))= C1 $3.50 | For (England + Snail ($5.30)= C1 $5.30 I thank you in advance for any consideration on my quest. Janvier -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Total remaining formula | Excel Worksheet Functions | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) | |||
ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) | |||
macro - adding rows to a column that is summed | Excel Discussion (Misc queries) |