Thank you very much.
Thanks
N.Sundarvelan
9600160150
On 24 March 2017 at 21:05, Swapnil Palande
wrote:
> Hi,
>
> There is no need of extra columns you have added in sheet 3 and sheet 1.
> Using "Sumproduct" formula you can get required output. Attached is the
> solution for your reference. I ho
Hi,
Need more explanation. If you could provide sample file then it is easy to
provide appropriate solution.
Have one query, if there is only one criteria then why are you using
"COUNTIFS" formula, use "COUNTIF" instead.
Regards,
Swapnil Suresh Palande.
On Fri, Mar 24, 2017 at 6:09 PM, Sundarv
Dear Friends,
Please help how to dynamically change the criteria range.
That is
=COUNTIFS(Sheet1!$AA:$AA,Sheet3!B$2)
=COUNTIFS(Sheet1!$AB:$AB,Sheet3!B$2)
=COUNTIFS(Sheet1!$AC:$AC,Sheet3!B$2)
Thanks
N.Sundarvelan
9600160150
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be
