If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
function like sumproduct??
Is there a function in Access that works like the Sumproduct function in
Excel? I have a report that pulls from a query that has many fields. What I want is for a field on the report to calculate the number of lines sold for a certain person. Let's say I have names of Jim, Jan, and Jimbo, and I have a product category of A, B, & C with products A1, B1, C1, D1, E1, F1, G1, H1, I1, J1, K1, L1, & M1 each product having a certain value for lines. I want to calculate how many total lines Jimbo sold when the product category equals A, and to count everything but E1 & J1. Hopefully that made sense. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to modify function | Kevin | General Discussion | 5 | January 4th, 2006 10:12 PM |
Excel option to store trendline's coefficients in cells for use | Miguel Saldana | Charts and Charting | 9 | June 20th, 2005 08:45 PM |
Automatically up date time in a cell | Mark | General Discussion | 5 | May 12th, 2005 12:26 AM |
sumproduct function | Andreea Moyes via OfficeKB.com | Worksheet Functions | 3 | February 24th, 2005 09:00 AM |
Sumproduct and Month Function | Mike Lee | Worksheet Functions | 4 | February 24th, 2004 09:05 AM |