LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
RUSH2CROCHET
 
Posts: n/a
Default Sum Product Function Question

Hello All:

Quick question on SumProduct...
Sheet 1 is a recap of processed returns for customers
A1=Sprint
A2=Verizon
Column B is January
Column C is February, and so on

Sheet 2 is a "tracking log" of returns
Column A contains the Date value, including month & year
A1 = January 13 - E1 contains "Sprint"
A2 = February 2 - E2 contains "Verizon"
A3 = March - E3 contains "Sprint"

I would like Sheet 1 to reflect the number of transactions within a specific
month per customer, that is to say....

Jan Feb Mar
Sprint 1 1
Verizon 1


All suggestions welcome!

Thanks!
Sandi
 
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
product function spiderman Excel Worksheet Functions 2 August 9th 05 08:08 PM
Complicated Sum Product Function Stacy M via OfficeKB.com Excel Worksheet Functions 0 August 5th 05 08:01 PM
Workday Function Question PA Excel Worksheet Functions 2 July 16th 05 03:08 AM
product function spiderman Excel Worksheet Functions 2 May 11th 05 01:14 PM
Function Related Question Sandeep Arora Excel Discussion (Misc queries) 1 February 2nd 05 07:36 PM


All times are GMT +1. The time now is 02:28 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"