LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PhilScratchingmyhead
 
Posts: n/a
Default help-sum filtered info on excel for more than one filter

On my spreadsheet I have info from more than one column filtered that I want
to add together onto another worksheet e.g if something in column 'A' = what
I want - then I want it to check if something in column 'B'= something else I
want...then if both criteria are met I want it to add data from column 'C'
onto another sheet. I have used sumif function but it only lets me check one
column and it's criteria but doesn't let me check the second column and it's
criteria before adding.

Any help would be appreciated as everyone here is stck in the dark ages and
were like Excel....huh????

Ta
P.

 
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
Excel 2000 filter problems Steve Walford Excel Worksheet Functions 2 June 8th 06 08:31 PM
Reflecting info between an excel file and a word one or two excel file. Starriol Excel Discussion (Misc queries) 0 November 3rd 05 01:49 PM
Excel 2003 doesn't filter correctly tclarke012 Excel Discussion (Misc queries) 2 August 7th 05 12:17 PM
Improve visibility of Excel AutoFilter Filter selections Cec Tarasoff Excel Worksheet Functions 0 June 22nd 05 08:56 PM
Excel 2003 Filter Problem bkbrueggemann Excel Discussion (Misc queries) 3 February 1st 05 11:49 PM


All times are GMT +1. The time now is 03:20 PM.

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"