sum or sum product???

[DBenson1968]

Hi guys
I want to work out the sum of a set of data in a table. I can filter to the data that I want, but this formula only counts the number of records and I want the sum of the figures in the table

=SUMPRODUCT(--('All Data'!$X$8:$X$391>0),--('All Data'!$C$8:$C$391='Front Cover'!$E$4),--('All Data'!$E$8:$E$391='Front Cover'!$B$10))

Any help is appreciated

Thanks
Dean

[Jonmo1]

You need to add the range that you want to SUM

=SUMPRODUCT(--('All Data'!$X$8:$X$391>0),--('All Data'!$C$8:$C$391='Front Cover'!$E$4),--('All Data'!$E$8:$E$391='Front Cover'!$B$10),'All Data'!$A$8:$A$391)

This will sum the values in column A based on the criteria you already 'counted'

[DBenson1968]

Once again Jonno saves the day.

Thanks again

Dean

[Jonmo1]

Glad to help, thanks for the feedback.