LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sally J
 
Posts: n/a
Default Looking up information based on Columns and Rows

I have a spread sheet that looks like this

CO. Month Amt
Apple 11 $5000
Apple 12 3000
Orange 11 500
Orange 11 300
Apple 11 50
Peach 11 6000
Apple 11 150

In a differnet spreadsheet, I want to look up each company based on the
month it is found in and sum the amounts given.

Example
November Spreadsheet
Co. Total
Apple 5200
Orange 800
Peach 6000

December Spreadsheet
Co. Total
Apple 3000
Orange -
Peach -

This will continue throughout the 12 months. the first spreadsheet is the
main one where information will be inputed. I need the formula to not only
look at the month but who the company is as well. I used to SUMIF function
when i was looking at just the month in general but now I need to add to the
formula so it will only add those rows that have the correct company
attached. Help will be much appreciated.

Thanks,
Sally
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum based on criteria in rows and columns EstherJ Excel Discussion (Misc queries) 1 November 1st 05 10:28 AM
How to swap rows and columns? [email protected] Excel Discussion (Misc queries) 5 September 21st 05 08:07 AM
autofill information from rows to columns without using transpose Rayce Excel Discussion (Misc queries) 1 September 4th 05 01:44 AM
Clearing information in certain columns jolly_lolly Excel Discussion (Misc queries) 1 April 22nd 05 02:41 AM
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns foofoo Excel Discussion (Misc queries) 1 April 2nd 05 12:02 AM


All times are GMT +1. The time now is 07:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"