View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
keerthyV keerthyV is offline
external usenet poster
 
Posts: 3
Default A conditional Sum & Count

Hi,

I have a query,

My data :
Days Type

Sunday Lunch
saturday Dinner
sunday Dinner
Saturday Dinner
sunday Lunch

without a Pivot,
I want a 2x2 matrix like(Count)
Lunch Dinner
saturday 1 2
sunday 2 1

Please can anyone sort it out for me????????

Keerthy