Thread: 2D sumif loop?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyeR
 
Posts: n/a
Default 2D sumif loop?

..

Unless I'm missing a post, all I see there is an *array* formula.<g
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Aladin Akyurek" wrote in message
...


RagDyeR wrote:
How about a nice, simple, single formula of:

=SUMPRODUCT((M5:M1000=C4)*(B5:J1000))


That is already done. See Roger's post.