Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
product function | Excel Worksheet Functions | |||
Complicated Sum Product Function | Excel Worksheet Functions | |||
Workday Function Question | Excel Worksheet Functions | |||
product function | Excel Worksheet Functions | |||
Function Related Question | Excel Discussion (Misc queries) |