Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 103
Default TEXT VALUES !!!

what's the equivalent to the sumif formula for text??
Ie:

Food Drinks

pizza

pizza

I want to put in a new colum the result ONLY IF says Food, so the result in
this case would be pizza. I want a formula that looks for the word "Food" and
copy the row.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Link Protected WorkBook ... and Get #N/A for Text Values! monir Excel Discussion (Misc queries) 5 April 26th 06 12:37 AM
Can anyone tell me how to hide rows that have 0 values and text. Aussie Charts and Charting in Excel 2 April 13th 06 10:57 AM
How do I LOOKUP text values Amber C-W Excel Worksheet Functions 4 July 20th 05 05:27 PM
Help adding text values Texas-DC_271 Excel Worksheet Functions 7 January 15th 05 11:14 PM
text and values combined in one cel Bart Excel Discussion (Misc queries) 1 December 14th 04 08:36 AM


All times are GMT +1. The time now is 04:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"