Need to sum data as per value define

[udprocks]

Dear All,

Can Anyone please help me with this, I want sum of days as per value define.

Thanks in Advance.

 

[Khalid NGO]

Hi Jitendra,
Good day.

Can you confirm this:
=SUMPRODUCT(COUNTIF(D2:D19,"P")+COUNTIF(D2:D19,"Leave"))

Regards,

 

[Khalid NGO]

Edit: Just realized Half day requirement instead of leave:
=SUMPRODUCT((D2:D19="P")+((D2:D19="H")/2))

 

[Debraj]

if you can sort the table..


then it will be much easier to sum.. like this.

=SUMPRODUCT(LOOKUP(D2:D19,A2:B6))

 

[Somendra Misra]

Hi Jitendra,

Try below formula:

=SUMPRODUCT(COUNTIF(D2:D19,A2:A6),B2:B6)

Regards,

 

[udprocks]

Hallo Khalid & Debraj sir,

Thank you for your quick support... both formulas are brilliant for me...

But as sweet and short way "Debraj" sir yes i can short that table no worries,..

Many thanks''' sir's.

 

[udprocks]

Hi Jitendra,

Try below formula:

=SUMPRODUCT(COUNTIF(D2:D19,A2:A6),B2:B6)

Regards,

Nice one again. thank you somendra sir.