ExcelBanter - sumif formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - sumif formula (https://www.excelbanter.com/excel-discussion-misc-queries/246893-sumif-formula.html)

ROHIT

sumif formula

i want to use sumif formual with a text.

eg =sumif(A1:A100,"ACC*",F1:F100). is this possible

Ms-Exl-Learner

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

All times are GMT +1. The time now is 12:05 AM.