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

Question

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


Configuration: Windows 7 / Chrome 32.0.1700.107

ac3mark · Answer

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!

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

1 response

Similar discussions

Subscribe To Our Newsletter!