Creating a Summary Worksheet

[smithgt]

I need to pull together a weekly summary of data contained in one of my worksheets.

I've created a new sheet call "Weekly Summary"

On "Sheet A", there are two columns that I need to consider for my summary.

Basically, If column F contains the value "Event1" then count the number of times the value "Developing" appears in column G.

I'm not sure this given enough info.

But, basically what I currently do is to copy the data into temp sheet, filter on column F and the subtotal for each change on column G. This is all manual, so I'm trying to automate it a bit.

 

[The Horse]

Hi - couldn't you just use a Pivot Table for this ?

Mick the Horse

 

[jeffreybrown]

If you have 2007+

=COUNTIFS(F2:F100,"Event1",G2:G100,"Developing")

If 2003

=SUMPRODUCT(--(F2:F100="Event1"),--(G2:G100="Developing"))

 

[smithgt]

Oooo. Just Discovered =COUNTIFS

This does the trick.