Sum cells

[maniche.jain]

Hi,


I have data in a format as under :


ram 20 121

mohan 20 15

manish 49 544

sita 954 154

geeta 21 12


How can i sum cells which contains "h" in column A??

 

[Hui]

Maniche


Firstly, Welcome to the Chandoo.org Forums.


Try: =SUMPRODUCT(1*(LEFT(A:A,1)="H"),(B:B)+(C:C))

 

[maniche.jain]

Hi Hui,


Thank you


But its not working, or may be i am not using it properly.


Waiting for your assistance


Thanks

 

[NARAYANK991]

Hi Jain ,


I think a slight change is required , since you have mentioned that the sum is required where column A names contain the letter "H" :


=SUMPRODUCT(1*(ISNUMBER(FIND("H",UPPER(A:A)))),(B:B)+(C:C))


or


=SUMPRODUCT(1*(ISNUMBER(SEARCH("H",(A:A)))),(B:B)+(C:C))


Narayan

 

[maniche.jain]

Thanks Narayan !!


Its working


Manish Jain