Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to add sales gross for individual salespeople, and break it down
by new vehicles vs. used vehicles. I have a column set up for the sales people, a column set up for the type (N or U), and a column set up for the gross that I want to add. I can make it add up the gross of new vs. used using the sumif function, but I don't know how to make it do "if this = this, and this = this, then add this through this". Does that make sense? I'm sure it's not as hard as I'm making it out to be. Can anyone help? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
Calculating an average based on 2 and 3 criteria | Excel Worksheet Functions | |||
move contents of column C based on criteria related to column A | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Count rows based on multiple criteria | Excel Worksheet Functions |