Hi,

I am trying to create a summary report detailing the number and value of new
projects dependent upon whether they are live/closed and by the stage they
are at or ended on.

A sample of the data looks like:

A B C
1 Status Stage Price
2 Closed Tender £890k
3 Active EOI £300k
4 Active BOT
5 Active BOT
6 Closed BOT £180k

and the report table I am trying to create curerntly looks like:

ACTIVE
Stage No. Contract Value
BOT 3 £180k
EOI 1 £300k
PQQ 0 £k
Tender 1 £890k
Interview 0 £k
Awarded 0 £k
Total: 5 £1,370k

and a similiar table for closed projects. However, orginally I was not
differentiating between active and closed so created a COUNTIF formula to
answer how many projects at each stage e.g. three BOT's as shown above. I
also used a SUMIF to provide the total value of contracts by stage type. Now
I want to expand both of these so that they only return results for active
cases - table 1 - and closed cases - table 2.

I am guessing I need an IF or AND formula combined with the originals but
need guidance how to write this please?

I have tried using answers to other questions on hear but no joy - but am
sure one of you more experienced people will be abel to quickyl point me int
eh right direction.

Thank you in advance for any assistance you can provide!

Damo 8o)