IF formula (part 2)

[singingsister]

I have a sheet which lists of company names and types of certain documents together with the date we recieve them (ie MacDonalds.....Order Sheet 1.......open/closed

What I want to do is have a statistics sheet where i can break down by company whether a certain document is open or closed.

What formula can I use?

 

[Jon von der Heyden]

Could you perhaps show by way of example using colo's html maker how you would want the output to appear?

My initial thinking is to use a pivot table using customer as a page field but it's a little difficult to be more specific.

Cheers

 

[onlyadrafter]

Hello

try (in G1)

=SUMPRODUCT(--($A$1:$A$10=E1),--($B$1:$B$10=F1))

where A1-A10 contains McDonalds etc

B1-B10 contains OPEN/CLOSED

E1 = Mcdonalds
F1 = open

you can then copy G1 down and add data to E2.. and F2...

also,

there is also Pivot tables