View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Heather Heather is offline
external usenet poster
 
Posts: 148
Default Sum of every time 2 different texts are found in 2 different colum

I am regarding as fairly Excel smart at work, however by comparison to these
questions I am an idiot.

I have a running list which rows are added to nearly everyday. Columns A €“
L are populated with different data. Specifically, column G has employee
names and column J has dates.

I have a summary page with all dates listed horizontally and all employee
names listed vertically. I would love it if, for example, on the summary
page under date (August 26th) and in the employee name row (Heather) the cell
would populate with the total number of times Heather and August 26th were in
the same row on the running list.

I hope this makes sense.

I appreciate any assistance.

Regards,
Heather