Automated_countno.of claims on the basis of claim type

[Ravindra]

CLAIMS CLAIM TYPE

2 HCFA

5 HCFA

2 MISC

5 DEN

3 MISC

4 UB

6 HCFA

4 HCFA

1 DEN

5 UB

6 HCFA

2 MISC

1 MISC


MISC HCFA UB DEN INVOICE TOTAL

0 0 0 0 0 0


Dear All,

I need automated logic for count no. of claims on the basis of their cliam type.

Since intitally I've given all the records in second sheet is zero.Since there is no any screen shot facility so I'm having to just paste my query like this.Now I have to manually count no. of HCFA'S claims,MISC'S claims and so on.So what logic should be used to count these record.


thanks and regards,,

ravindra bisht .

 

[vijaySharma]

@Ravindra,


You can use the COUNTIF function to easily do this. ir you need the sum use SUMIF


~VijaySharma

 

[sgmpatnaik]

Hi Ravindra


Firstly welcome to Chandoo.org Forums


you can use the sumifs formula


in sheet2


ColumnA ColumnB

HCFA

MISC

DEN

UB


formula in ColumnB


=SUMIFS('Sheet1'!A$2:A$14,'Sheet1'!B$2:B$14,A2) and drag down to below


With Regards


SP

 

[nazmul_muneer]

Dear Ravindra,

Think your data from A2 to B14

Type D2=HCFA

Type E2=COUNTIF(B:B,D2) --for How many times HCFA is existing

Type F2=SUMIF(B:B,D2,A:A) --for summation of claims according to HCFA


Regards,


Muneer

 

[sdsurzh]

Hi,


Can you please download the below and press Control+q.


http://www.2shared.com/file/31HKyTKv/Book3.html


Thanks,

Suresh Kumar S

 

[nazmul_muneer]

Dear Suresh Kumar,

For simple problem, simple solution is enough.


Regards!


--Muneer

 

[sdsurzh]

Dear Muneer,


Ravi has mentioned in his statement like Dear All, I need automated logic..... So i have tried my level best.


Thanks,

Suresh Kumar S