SUM range based on count

[delboy2405]

I have a table that has around 3000 rows that goes back around 3 years.

I have a calculation that could how many of these are based this year using the forumula

Please Login or Register  to view this content.

I'm now looking to to expand that to sum the number of instances by another column

So currently the above forumla brings back a result of 29, i'm looking to them sum the figures in Column d (Know as Table3[Number of Incidents]) for those 29 rows

Hope that makes sense

[Pete_UK]

Try this:

Please Login or Register  to view this content.

Hope this helps.

Pete

[delboy2405]

Pete,

I just get the standard you formula contains an error message

Try this:

Please Login or Register  to view this content.

Hope this helps.

Pete

[delboy2405]

Please Login or Register  to view this content.

Works, cheers. Just a few missing ) Pete, cheers