Add IF Excel 2013 formula to sum all those items with code

Closed
Kunvarharsh Posts 1 Registration date Thursday April 3, 2014 Status Member Last seen April 3, 2014 - Apr 3, 2014 at 03:36 AM
 Blocked Profile - Apr 3, 2014 at 04:59 PM
Hello,

I am Dr Kunvar Harsh from India

I wanted to know if there is any way I can put formula to sum all those items with code e.g E C, H C, K C, KH C (common account) separately from the whole list of item codes having various codes like E H, E S, K H, K S etc..

Thank you


Related:

1 response

Blocked Profile
Apr 3, 2014 at 04:59 PM
Dr. Welcome.

You can USE COUNTIF(). As in this:

Countif(rangofcells,"what_are_you_lloking_for")

I hope this gets you further:



Have FUN DOC!
0