$ value in column J
Accepted in column M
Date in column N
Sales Rep Name (3 different reps) in Column R
I need a formula based on the $ value ACCEPTED in the month of September and by sales rep name. Any help would be greatly appreciated.
Kat![]()
$ value in column J
Accepted in column M
Date in column N
Sales Rep Name (3 different reps) in Column R
I need a formula based on the $ value ACCEPTED in the month of September and by sales rep name. Any help would be greatly appreciated.
Kat![]()
Hi Chykat2000,
Sounds as though a PivotTable would be the simplest option, can you upload a sample workbook?
There are lots of elements for this workbook. I have a tab for every month and hidden tabs to calculate the formulas I need that feed into another spreadsheet. This is the only formula that I can't figure out
Book 1.xlsx
Hi Kat,
Not sure if the attached is what you are looking for. I've simply added a PivotTable with a Date and a Status filter. If this doesn't give you what you need, let me know which cell/s on your data sheet you are looking to show these totals...
I know how to do a pivot table. I need a formula that will calculate based on the $ value ACCEPTED in the month of September and by sales rep name. I have 20 airports that I have to compile data into 1 spreadsheet.
If Accepted (column M), Between 9/1-9/30 (Column N), Calculate the $ value (Column J) for specific rep name lets say Katrina (Column R)
Try this formula
=SUMPRODUCT(($J$2:$J$100)*($M$2:$M$100="Accepted")*(MONTH($N$2:$N$100)=9)*($R$2:$R$100=R2))
R2="KATRINA TAYLOR"
Create list of Sales Rep say AA2:AA20 , formula in AB2 ,and replace R2 with AA2 and copy down.
In which case try:
and adjust the range according to the number of rows you have... I've restricted it to Rows 2 to 82 because this is the limit of the data in your sheet and because you have totals at the bottom of column J.![]()
Please Login or Register to view this content.
Let me know if that works for you?
Last edited by HangMan; 09-22-2015 at 03:59 PM.
The sumifs formula worked perfectly, thank you so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks