Matt Pinkston
asked on
need help with excel formula or lookup
I have an XLS with two tabs
Report
Chart
Report is the raw report and chart is where I want to summarize values, if I get one I should be fine to do the rest...
so in cell C3 of chart I would like the total number of records from Report when:
Report Column L = Civilian
Report Column N begins with 01,02 or 03
in cell C11 of chart I would like the sum of Report Column G when:
Report Column L = Civilian
Report Column N begins with 06
Report
Chart
Report is the raw report and chart is where I want to summarize values, if I get one I should be fine to do the rest...
so in cell C3 of chart I would like the total number of records from Report when:
Report Column L = Civilian
Report Column N begins with 01,02 or 03
in cell C11 of chart I would like the sum of Report Column G when:
Report Column L = Civilian
Report Column N begins with 06
Jan Karel Pieterse
Perhaps two pivottables would do the trick? Easier than formulas.
ASKER
well I have dozens of these that is why I was hoping to get a couple formulas then I can make them work for the rest
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
perfect for the first scenario how about
in cell C11 of chart I would like the sum of Report Column G when:
Report Column L = Civilian
Report Column N begins with 06
in cell C11 of chart I would like the sum of Report Column G when:
Report Column L = Civilian
Report Column N begins with 06
Have you tried my SUMIFS suggestion?