Posted to microsoft.public.excel.misc

wx4usa

external usenet poster

Posts: 122

Sumproduct question

I just want to count the number of entries, not a sum of totals.
column A is Month, B is Day, C is year, D is Name

Can I use sumproduct to just return the number of entries for "Bob" on
August, 1, 2007? Bob may have anywhere from 1-20 lines of data in
this scenario, I just want to know how many occurrences, not an actual
sum of some numbers.

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 question	Conan Kelly	Excel Worksheet Functions	2	January 5th 07 08:26 PM
A SUMPRODUCT question	Bernard Liengme	Excel Discussion (Misc queries)	3	October 17th 06 06:36 PM
Sumproduct question	Barb Reinhardt	Excel Worksheet Functions	1	September 7th 06 10:38 PM
Sumproduct question	Barb Reinhardt	Excel Worksheet Functions	3	June 26th 06 05:17 PM
Sumproduct Question	Barb Reinhardt	Excel Worksheet Functions	2	May 15th 06 09:25 PM

All times are GMT +1. The time now is 03:06 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us