If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Conditional" summing
In B2 on the destination sheet enter & copy down:
=SUMIF(Sheet1!A:A,A2,Sheet1!B:B) Replace Sheet1 with the name of your source sheet. Gilbert De Ceulaer wrote: How do I do this ? I have a datebase in one sheet. In column A are names, let us say of products; they are NOT unique, and NOT sorted. In column B there are numbers, let us say amounts. In another sheet, I want to know the total number for the different names. In column A are the names, unique in that sheet, but not necessarily sorted. In column B I would like to have the total of the numbers corresponding to that name from sheet number one. As normal, I already tried several possibilities. Gilbert De Ceulaer |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need Help! Conditional Summing | S.J. Powell | Worksheet Functions | 1 | September 18th, 2004 02:24 PM |
Conditional Number Formatting & Selective Summing | donkirk | General Discussion | 0 | June 23rd, 2004 06:02 PM |
Conditional Summing up of Cell values | Paul | Worksheet Functions | 0 | December 23rd, 2003 11:52 AM |
Conditional summing question | Steve Conway | Worksheet Functions | 7 | November 14th, 2003 10:50 PM |