| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Looking to added up based on a character from cell range
Hi,
I am looking for idea, how to add up cell range a1:a3 based on the values in b1:b3 and c1:c3 A B C D 1 3 A S =SUMIFS(A1:A2,B1:B2,"S",C1:C3,"<A") =4 2 4 S Z 3 5 Z A,S Looking to formulate the above formula to arrive same answer. In D3, I need to write the formula in such way it takes the character A from C3 to calculate the sum. In another word, how to find the character from cell range Last edited by SudarCR : October 23rd 12 at 10:52 PM |
|
#2
|
|||
|
|||
|
=SUMIFS(A1:A3,B1:B3,"A",C1:C3,"<A")
Quote:
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| deleting a cell based on character length? | Excel Programming | |||
| Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
| Can column character be added? | Excel Programming | |||
| looping thru range extracting data based on character | Excel Programming | |||
| how to format only a specific character or number in each cell withina range of cells | Excel Worksheet Functions | |||
Linear Mode
