SumIf statement help

%3CLINGO-SUB%20id%3D%22lingo-sub-2927990%22%20slang%3D%22en-US%22%3ESumIf%20statement%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2927990%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20two%20issues%20I%20am%20need%20of%20assistance%20with%20today.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20I%20was%20wondering%20how%20you%20make%20a%20sumif%20statement%20read%20a%20cell%20that%20just%20has%20any%20type%20of%20content%20in%20it.%20I%20need%20to%20sum%20up%20a%20list%20of%20prices%20of%20items%2C%20but%20filter%20them%20through%20another%20column%20with%20their%20designated%20floor%20level%2C%20but%20the%20cells%20are%20filled%20with%20the%20dates%20of%20work%20done%2C%20so%20they%20are%20all%20different%20content%20in%20each%20cell%20even%20if%20they%20are%20on%20the%20same%20floor.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20Is%20there%20a%20way%20I%20can%20create%20sumif%20statements%20that%20filter%20through%20a%20specific%20word%20such%20as%20%22John%22%20and%20the%20color%20I%20have%20filled%2Fhighlighted%20the%20cell%20with%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2927990%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2932663%22%20slang%3D%22en-US%22%3ERe%3A%20SumIf%20statement%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2932663%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1207320%22%20target%3D%22_blank%22%3E%40Sean-Sweeney%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20can%20recommend%20you%2C%20always%20include%20a%20file%20(without%20sensitive%20data)%20whenever%20possible.%3C%2FP%3E%3CP%3EAt%20the%20same%20time%2C%20information%20about%20your%20Excel%20version%20as%20well%20as%20the%20operating%20system%20would%20be%20advantageous%20in%20order%20to%20provide%20you%20with%20a%20faster%20and%20more%20accurate%20solution%20proposal.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20you%20have%20specified%2C%20I%20will%20send%20you%20this%20inserted%20file%20with%20an%20example.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20that%20I%20could%20help%20you%20with%20this%20example%20inserted%20in%20the%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolinoDE%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi two issues I am need of assistance with today.

 

1. I was wondering how you make a sumif statement read a cell that just has any type of content in it. I need to sum up a list of prices of items, but filter them through another column with their designated floor level, but the cells are filled with the dates of work done, so they are all different content in each cell even if they are on the same floor.

 

2. Is there a way I can create sumif statements that filter through a specific word such as "John" and the color I have filled/highlighted the cell with? 

 

Thank you!

1 Reply

@Sean-Sweeney 

If I can recommend you, always include a file (without sensitive data) whenever possible.

At the same time, information about your Excel version as well as the operating system would be advantageous in order to provide you with a faster and more accurate solution proposal.

 

After you have specified, I will send you this inserted file with an example.

 

I hope that I could help you with this example inserted in the file.

 

NikolinoDE

I know I don't know anything (Socrates)