|
Formula Help
ColumnA Column B ColumnC ColumnD
$2,958.73 Kelly RSP 5-Feb-07 $91,000.00 Sherri Non-Reg 12-Feb-07 $15,648.47 Kelly RRIF 21-Mar-07 These are my columns. I want to make a running total for each salesperson PER QUARTER. So if their name appears in Column B AND Jan, Feb or Mar appears in Column D, I want it to add their sales numbers from Column A to this quarterly total: Ex) Kelly appeared in Col B AND Feb appeared in Column D so it added $2958.73 to her total quarterly sales: Kelly 1st Quarter Sales $18607.2 |
Formula Help
F1: holds person name
=SUMPRODUCT((rngB=F1)*(MONTH(rngD)={1,2,3})*rngA) "cdw" wrote: ColumnA Column B ColumnC ColumnD $2,958.73 Kelly RSP 5-Feb-07 $91,000.00 Sherri Non-Reg 12-Feb-07 $15,648.47 Kelly RRIF 21-Mar-07 These are my columns. I want to make a running total for each salesperson PER QUARTER. So if their name appears in Column B AND Jan, Feb or Mar appears in Column D, I want it to add their sales numbers from Column A to this quarterly total: Ex) Kelly appeared in Col B AND Feb appeared in Column D so it added $2958.73 to her total quarterly sales: Kelly 1st Quarter Sales $18607.2 |
| All times are GMT +1. The time now is 05:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com