Multiple Values Total, Multiple Sheets (SUM/COUNTIF)

[James95]

Hi All,

I've been working on this spreadsheet for a while now.

On the 'Monthly Error Total' page, I'm trying to filter across the whole workbook (01-04 JUN - It will be 30 when it's complete).

What I'm trying to achieve is filter the value N on the dates by filter it by name so it shows a total number of N's for a specific name across the whole month.

For example, in cell D9, I'd like to work out how many N (failures) Bob has across the whole month. The aim is to do that for every heading and name.
So far i've tried a indirect sum product, but it's only for one value, =SUMPRODUCT(COUNTIF(INDIRECT("'"&#REF!&"'!N6:N36"),"N")).

Any help is appreciated.

Thanks in advance.

[oeldere]

If it was my file, I would remove the merged cells, since you could get problems with that.

Second: I would make a 1 sheet with all data and dates in it. Use 1 column for the date.

That makes it a lot easier to analyse the data.

[ORoos]

Agree with oeldere.
If you really need the data on a separate sheet for each day, you could use a macro to split the master data into the sheets (based on the date to the sheet with the corresponding sheet...

[Bo_Ry]

Please try at D9

=SUMPRODUCT(COUNTIFS(INDIRECT("'"&$A$27:$A$30&"'!F6:F50"),$A9,INDIRECT("'"&$A$27:$A$30&"'!R6C[11]:R50C[11]",),$C$27))

[James95]

Worked perfectly. Thank you so much!