I have a spreadsheet of data which I need to analyse results from.

Two of the columns, 'severity' and 'priority' contain string values
relating to the severity and priority of QA issues.

Severity, for example contains values like "Crash, Fatal, Normal, Tweak"
Priority contains values like "Immediate, Urgent, Normal, Low"

I have a lookup that converts these two values to a single severity of A, B
or C (IE Crash+Immediate = A, Crash+Low = B)

How can I get a count of the number of A, B and C issues from my spreadsheet?

I've tried using things like COUNTIFS on the data collection page, but I
can't embed my LOOKUP statement inside it and have it scan all the lines on
the database page.

Put simply, for each line of my database worksheet, I need to get the value
of a LOOKUP from two columns and add up all those that equal, say, "A"

I don't want to have a lookup statement on each line of my database
worksheet as it's imported each day from a CSV.

------
&e7

(UM, did I say LOOKUP... I meant INDEX where severity is horizontal and
priority is vertical) D'Oh!

------
&e7


"&e7" wrote:

I have a spreadsheet of data which I need to analyse results from.

Two of the columns, 'severity' and 'priority' contain string values
relating to the severity and priority of QA issues.

Severity, for example contains values like "Crash, Fatal, Normal, Tweak"
Priority contains values like "Immediate, Urgent, Normal, Low"

I have a lookup that converts these two values to a single severity of A, B
or C (IE Crash+Immediate = A, Crash+Low = B)

How can I get a count of the number of A, B and C issues from my spreadsheet?

I've tried using things like COUNTIFS on the data collection page, but I
can't embed my LOOKUP statement inside it and have it scan all the lines on
the database page.

Put simply, for each line of my database worksheet, I need to get the value
of a LOOKUP from two columns and add up all those that equal, say, "A"

I don't want to have a lookup statement on each line of my database
worksheet as it's imported each day from a CSV.

------
&e7