Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The best way I can describe what I need is by example, so here goes!
I am currently creating a spreadsheet which is capturing information in both English and French. At month's end, we need to keep stats on how many entries of certain elements we are getting. However, due to the bilingual nature of our company, entries are being entered in both English and French. Rather than creat two COUNTIF functions for both elements, is there a way I can combine them to capture both terms and put them in the same COUNTIF Total? What I mean: Categoy: Animal English term: Dog French term: Chien Actual Entries: Dog Dog Chien Dog Chien Total entries which should show up: 5 Does an "either or" function exist which can help me out? I'd rather not creat two COUNTIF functions for this. Is there any way to combine them? thanx S. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
How do I write "Either / Or" Display Formulas? | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |