LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
colum is not found thats missing a column B how to find it meena Excel Worksheet Functions 1 July 17th 09 10:36 AM
Sumif a date time colum and information JMB Excel Discussion (Misc queries) 6 March 20th 08 06:34 AM
Look up a value in one colum and insert the value found in the adj lgr021238 New Users to Excel 1 December 17th 07 07:28 PM
Keeping a sum colum correct after inserting a colum of data in fro hazel Excel Discussion (Misc queries) 3 October 19th 05 09:51 PM
Check data on colum A and find match on colum b Chris(new user) Excel Discussion (Misc queries) 3 March 20th 05 04:45 PM


All times are GMT +1. The time now is 12:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"