$$Excel-Macros$$ Help req - sumif sumifs or countif countifs

Dear seniors, How can we use sum sumifs , countif countifs. and what is the diffrence between. pls explain with formula and example. pls help me. thanks Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page

Re: $$Excel-Macros$$ Help req - sumif sumifs or countif countifs

Sumif - used to sum the range by checking single condition. Sumifs - used to sum the range by checking multiple conditions. Countif - used to count the range by checking single condiyion. Countifs - used to count the range by checking multiple conditions. On Jul 29, 2013 8:28 PM, Ashish Kumar

Re: $$Excel-Macros$$ Help req - sumif sumifs or countif countifs

Hi Ashish, Just go through this link... you have good examples... http://chandoo.org/wp/2008/11/12/using-countif-sumif-excel-help/ Thanks, Raj On Mon, Jul 29, 2013 at 8:41 PM, Prabhu Pinky prabhupin...@gmail.comwrote: Sumif - used to sum the range by checking single condition. Sumifs -

Re: $$Excel-Macros$$ Help req - sumif sumifs or countif countifs

Dear Rajasekhar, THanks On 29 July 2013 21:00, Rajasekhar Praharaju rajasekhar.prahar...@gmail.comwrote: Hi Ashish, Just go through this link... you have good examples... http://chandoo.org/wp/2008/11/12/using-countif-sumif-excel-help/ Thanks, Raj On Mon, Jul 29, 2013 at 8:41 PM,

Re: $$Excel-Macros$$ Help req - sumif sumifs or countif countifs

Dear Prabhu, THANKS A LOT. On 29 July 2013 20:41, Prabhu Pinky prabhupin...@gmail.com wrote: Sumif - used to sum the range by checking single condition. Sumifs - used to sum the range by checking multiple conditions. Countif - used to count the range by checking single condiyion. Countifs