Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Functions

Excel Functions

ResolvedVersion 2007

Fri 14 Feb 2014, 16:38 Delegate Amy said...

Amy has attended:
Excel Advanced course
Word Advanced course
PowerPoint Intermediate Advanced course

Excel Functions

I need to create a table that totals the amount from another table on another sheet using text. Is there a formula that can do this?

Happy to send through example of what I require if needed.

Thanks

Wed 19 Feb 2014, 09:15 Trainer Andrew said...

RE: Excel Functions

Hi Amy

thank you for your question. Yes it would be good to see an example. I am interested in the text component particularly.

You can email it for my attention at forum@stl-training.co.uk

Looking forward to hearing from you.

Kind regards,
Andrew

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Counting Non Number Cells (Text)

If you try to use the COUNT FUNCTION =COUNT(Cell range)with a range of cells with numbers and or containing text fields you wil find that that the text cells will be excluded from the the count. If you want to include them try the the COUNTA FUNCTION =COUNTA(Cell range). This counts both text and number cell values.

View all Excel hints and tips

Excel Functions

Excel Functions

RE: Excel Functions

Excel articles

Excel tip:

Counting Non Number Cells (Text)