Posted to microsoft.public.excel.misc

wx4usa

external usenet poster

Posts: 122

Sumproduct entire month from mmddyyy?

In A1 I have the date: mmddyyy. I need a sumproduct formula to return
the sales for a sales person for the entire month and year for the
date in A1 even though just one day is entered into A1. Unfortunately
on this report, I can only reference the mmddyyy date in A1.

A2:A1000 has dates mmddyyy for each sale made
B2:B1000 has salesperson that made the sale
C2:C1000 has sales amount of each sale

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Sumproduct mmddyyy just the month?	wx4usa	Excel Discussion (Misc queries)	2	January 8th 10 12:47 AM
sumproduct calculation does not calculate entire range	John Gregory	Excel Discussion (Misc queries)	5	September 11th 09 09:16 PM
SUMPRODUCT - Using Month	Phendrena	Excel Worksheet Functions	15	August 18th 08 07:15 PM
SUMPRODUCT - Using Month	Jarek Kujawa[_2_]	Excel Worksheet Functions	0	July 15th 08 11:56 AM
Problem with sumproduct and month=1	bobh727	Excel Worksheet Functions	6	February 15th 05 07:13 AM

All times are GMT +1. The time now is 06:31 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us