Re: FW: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

2011-09-02 Thread NOORAIN ANSARI
Dear Amit, You can use Sumproduct instead of Countifs for Multiple Criteria.. See example.. =*SUMPRODUCT(--(A2:A30=F24)*(B2:B30=G24)*(C2:C30=H24))* -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* On Fri, Sep 2, 2011 at 3:21

FW: $$Excel-Macros$$ Option for countifs & Sumifs formula in MS Excel 2003

2011-09-02 Thread Amit Desai (MERU)
Dear Rajan, Thanks for this..but I do want to edit the attached formula, please explain the same how to do ? Also I want to have the formula with criteria of either or (in countifs we used to add 2 count ifs) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf