Another one i need deciphering...

I have a spreadsheet where a colum has the same drop down in every box with 2 choices eg new business & existing business. in the adjacent column there is a monetary value of that business. on a seperate sheet i need to be able to show the sum total of new business and existing busness. how do i seperate the 2 types of revenue out?

Dan

Here are a couple options.

With Sheet1
Col_A cells containing "New Business" or "Existing Business"
Col_B cells containing numeric values associated with Col_A

Then...on Sheet2
A1: New Business
A2: Existing Business

B1: =SUMIF(Sheet1!A:A,A1,Sheet1!B:B)
Copy B1 into B2

OR....you could create a Pivot Table, based on the Sheet1 data, that would automatically pickup all business types (along with any other column headings you might have) and allow you to quickly analyze the data.

Does that help?
(Post back if you have more questions)

Regards,

Ron
Microsoft MVP (Excel)

Hi,

What you have put seems like it could be quite simple but i dont know what do do with what you have said. for part 1:

With Sheet1
Col_A cells containing "New Business" or "Existing Business"
Col_B cells containing numeric values associated with Col_A


Where do i type this instruction?
and then the following bit - where do type that bit?

Then...on Sheet2
A1: New Business
A2: Existing Business

B1: =SUMIF(Sheet1!A:A,A1,Sheet1!B:B)
Copy B1 into B2

Sorry to be so dim, i am a beginner with excel but getting there bit by bit.

Dan

Hi, Dan

I apologize for not being clearer.

Those aren't programming instructions; they're just describing the set up.
References, like "A2: ", just indicate what cell will receive what I typed to the right of that reference.

Example:
This means type: "New Business" into cell A1 (without the quotes)
A1: New Business

This part just states what values will be in Sheet1
>>With Sheet1
>>Col_A cells containing "New Business" or "Existing Business"
>>Col_B cells containing numeric values associated with Col_A

...and this part gives you instructions on what to put in Sheet2
>>Then...on Sheet2
>>A1: New Business
>>A2: Existing Business

...this part tells you what formula to use and that you should copy/paste it
>>B1: =SUMIF(Sheet1!A:A,A1,Sheet1!B:B)
>>Copy B1 into B2

Let me know if you have more questions.

Regards,

Ron
Microsoft MVP (Excel)