LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default 2 Conditions + Sum of a colum matching those conditions

Ok.. I've spent the last 2 hours reading this area trying to find a close
enough match to what I am looking for. I know this will be simple.. but I've
ended up having to post.. I'm sorry :(.

This is what I have..

Col c = windows desktop or windows laptop
Col g = It's monthly $ charge
Col o = Who it is owned by (Finance companies)

I would like to have a breakdown of Desktops laptops with a cost item.. For
example

If col c = "Windows Desktop" & Col o = "HP Finance" Sum(g:g) (what's left
after the 2 conditions are met.

Hope that makes sense.. I'd love some help :)
Regards,

Jeffrey
 
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
shade cells based on conditions - i have more than 3 conditions Mo2 Excel Worksheet Functions 3 March 30th 07 07:19 AM
If's conditions about matching 0-0 Wai Wai ^-^ Excel Worksheet Functions 8 May 12th 06 06:27 PM
sum on conditions..... pimar Excel Discussion (Misc queries) 6 May 31st 05 05:00 AM
IF, AND, OR conditions? MEJ Excel Worksheet Functions 3 March 30th 05 05:37 PM
How to multiple conditions to validate more than 2 conditions to . Bhuvana Govind Excel Worksheet Functions 1 January 28th 05 07:07 PM


All times are GMT +1. The time now is 09:38 PM.

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

About Us

"It's about Microsoft Excel"