Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Referencing adjoining cells and counting in an IF statement
I'm looking for some type of formula or function that will allow me to
do the following: In a large spreadsheet, I need to count every cell that has the word "sick" with a cell to the left or right that has the word "vacation". (It's actually a little more complicated than that, but if someone can give me a formula to do that, I can do the rest myself.) Any help would be greatly appreciated. Brenda |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
join data in multiple cells when adjoining cells match criteria ?? | Excel Worksheet Functions | |||
Adjoining Cells | Excel Worksheet Functions | |||
Referencing adjoining cells and counting in an IF statement | Excel Programming | |||
referencing cells including an IF statement??? | Excel Worksheet Functions | |||
3 criteria must exist in adjoining cells then rtn val from 4th | Excel Discussion (Misc queries) |