Look at Data in D & E. If blank, and if column C = "studio", then count
occurrences.

C D E
Studio Allen Barnes
Private Jones
Studio
Double Hayes Hayes
Studio Taylor
In this case, the answer should be (3).
OR, IF POSSIBLE, would like to look at blanks, and deliver totals of C, i.e.
Studio = 3, Private = 1

Also, would it be possible to look at multiple sets of columns, Look at D,
E, H, I and deliver summary from C and G?

Try this:

=SUMPRODUCT((C2:C6="studio")*(D2:E6=""))
=SUMPRODUCT((C2:C6="private")*(D2:E6=""))

>Also, would it be possible to look at multiple sets of
>columns, Look at D, E, H, I and deliver summary
>from C and G?

Just string them together:

=SUMPRODUCT((C2:C6="studio")*(D2:E6=""))+SUMPRODUCT((G2:G6="studio")*(H2:I6=""))

--
Biff
Microsoft Excel MVP


"Blueagm" <(E-Mail Removed)> wrote in message
news:A5D86E6C-318C-4E81-BD5E-(E-Mail Removed)...
> Look at Data in D & E. If blank, and if column C = "studio", then count
> occurrences.
>
> C D E
> Studio Allen Barnes
> Private Jones
> Studio
> Double Hayes Hayes
> Studio Taylor
> In this case, the answer should be (3).
> OR, IF POSSIBLE, would like to look at blanks, and deliver totals of C,
> i.e.
> Studio = 3, Private = 1
>
> Also, would it be possible to look at multiple sets of columns, Look at D,
> E, H, I and deliver summary from C and G?