| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif formula
i want to use sumif formual with a text.
eg =sumif(A1:A100,"ACC*",F1:F100). is this possible |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sumif formula
I dont know what difficulty you are facing since the formula is correct. The
formula you have mentioned in your above post will get you the sum value of the text which are all starting with €œACC€ in A1 to A100. If this post helps, Click Yes! -------------------- (Ms-Exl-Learner) -------------------- "Rohit" wrote: i want to use sumif formual with a text. eg =sumif(A1:A100,"ACC*",F1:F100). is this possible |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sumproduct formula within a sumif formula. | Excel Discussion (Misc queries) | |||
| sumif formula doesn't add up | Excel Discussion (Misc queries) | |||
| multiply formula where 1 cell has a (sumif) formula as a result | Excel Worksheet Functions | |||
| sumif formula | Excel Worksheet Functions | |||
| Is there a MAXIF formula similar to the SUMIF formula? | Excel Discussion (Misc queries) | |||
Hybrid Mode
