Hi Dears
Hope you will Help me, Example =countif(a1:a20,"<10")and(b1:b20,"=Cancel")
so what i want " Count Coloumn A cells if <10 and if Coloumn B meet Cancel"
Hi Dears
Hope you will Help me, Example =countif(a1:a20,"<10")and(b1:b20,"=Cancel")
so what i want " Count Coloumn A cells if <10 and if Coloumn B meet Cancel"
Last edited by daddylonglegs; 08-16-2009 at 01:59 PM.
lalicom, our forum rules don't allow "thread hijacking" so I've made this into a thread of its own.....
Try using SUMPRODUCT, e.g.
=SUMPRODUCT((A1:A20<10)*(B1:B20="Cancel"))
Hi Friend
Your Formula is Perfect Thank you very much.
sorry
is it Possible ? =SUMPRODUCT((C:C<1)*(E:E<>"Cancel"))
No -- you can't use full-column references in SUMPRODUCT in Excel 2003.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks