Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 108

sumproduct over 2 rows of which one is a date

I have 2 columns one is date & the other is text - I need a formula to tell
me how many times each text appears on each date

I thought =Sumproduct((A1:A200="date")*(B1:B200="Text")) would work. The
even more complicated bit is the "date" bit is in a cell to enable it to be
copied down

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 against rows, columns	Scott A[_2_]	Excel Worksheet Functions	2	January 24th 08 06:18 PM
sumproduct last 30 rows	Nick Krill	Excel Worksheet Functions	2	July 3rd 07 03:02 PM
SUMPRODUCT - Ignore blank rows	sahafi	Excel Worksheet Functions	8	June 13th 07 06:11 PM
SUMPRODUCT with varying # of rows	Ren	Excel Worksheet Functions	5	June 27th 06 11:28 PM
sumproduct and even numbered rows	Jack Sons	Excel Discussion (Misc queries)	6	March 30th 05 11:24 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us