Hi Marielle

You have changed the criteria a little
Assuming your data table is located in A1:B10 with headers in row 1
Assuming your report table has Window in H1, Floor 1 in I1, Floor 2 in
J1, Floor 3 in K1 and has V3.1 in H2 and V3.2 in H3

enter is cell I2
=SUMPRODUCT(--($A$2:$A$10=$H2),--($B$2:$B$10=--RIGHT(I$1)))
copy across through cells J2:K2
copy I2:K2 to I3:K3

--
Regards

Roger Govier


"Marielle" wrote in message
...
Hi and thanks!

Unfortunately I still don't get the result I want... I must still be
doing
something wrong... Or are there other ways to do it? I'll try to
explain a
bit mo

Here's an example of the table I use:

Window type Floor Size Etc.
V3.1 1
V3.1 1
V3.1 2
V3.1 3
V3.1 3
V3.1 3
V3.2 1
V3.2 1
V3.2 2

I want the formula to count how many of each window type there are in
each
floor. In this case the result would be:

Window type Floor 1 Floor 2 Floor 3
V3.1 2 1 3
V3.2 2 1 0

I hope you can help me. I've been stuck with this problem for two
days!
Thank you ;o)

Marielle


"Roger Govier" wrote:

Hi Marielle

One way
=SUMPRODUCT(--(A1:A30="V"),--(F1:F30="A"))

--
Regards

Roger Govier


"Marielle" wrote in message
...
I want to create a countif formula containing two areas and
conditions,
i.e.
=countif(A1:A30;"V1") AND (F1:F30;"A"). How do I write the formula
to
make
it work? Please help...