Recent content by arivlin

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...

Thank you very much Hui. I was able to use IF(ISBLANK(A2),COUNTIF(range,"*")).

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"...