I just created a simple formula that does almost the entire function.
=SUMPRODUCT((C9:C3004=C2)*(E9:E3004=E2)*(F9:F3004=F2))
The C2, E2, and F2 fields are drop downs of all of the selections that may exist. The one missing element is if I wanted to leave one of those (C2, E2, or F2) blank...
I am trying to create a formula that I am afraid is beyond the scope of excel. My first question is - Is it beyond the scope? and second - Do you have any suggestions as to what to use for what I am doing?(ie. crystal reports, jreports, etc.)
I have a worksheet that has multiple fields to...
Hello,
I am trying to create a formula that uses (dynamic) data in a cell that has a drop down menu. However, if I leave the cell blank I want it to use the cumulative data from everything in the drop down combined.
For example: I have multiple sales people and I have a drop down menu that...
I have a multiple page spreadsheet and I am trying to complete a chart page for the data in the earlier pages. The spreadsheet tracks "Sales Opportunities" by "Product Type" and by "Salesperson". There are 29 "Salespeople" and 30 "Product Types", I would like to display each "Salespersons"...