Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Here's the senario. Column A has dates of sales. Column B has the sales
person's name. Column C has the amount of the sale. What I am looking for is a sumif statement that will total the sales in column C by salesperson in between specific dates. So for example, I want all the sales for John Smith totaled between the dates of 4/1/05 and 4/30/05. I've tried a bunch of different things but have had no luck getting this to work. Any help is appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I use the sumif if I have multiple criteria (i.e. greater . | Excel Worksheet Functions | |||
SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
SUMIF using VLOOKUP as criteria | Excel Worksheet Functions | |||
"criteria" in a sumif refering to the value in another cell | Excel Discussion (Misc queries) | |||
Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions |