Posted to microsoft.public.excel.worksheet.functions
|
|
Formula to use to count instances of in Excel
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
Regards,
Peo Sjoblom
"SteveG" wrote in
message ...
Ron's is definitely a simpler version. I just started experimenting
with SUMPRODUCT so thanks Ron. I have seen this used many times on
this site but don't fully understand what the -- that preceeds the
conditions do. I've searched on the Help files with no luck. Any
quick way to explain? Is there a site that you could suggest?
Thanks,
Happy Holidays.
Steve
--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=495488
|