Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summation question
Hi all,
I have a large spreadsheet and I want to make it work faster. Initially, I perform a check in some cells of the same row (eg I1 to L1) if they contain a specific word. Additionally, I need count that word only once in every row. Thus the function is like: =IF(COUNTIF(I1:L1,"*Word*")1,1,COUNTIF(I1:L1,"*Wo rd*")). My problem is that I need to add all the results of the functions (one from every row) and sum them at the end, without using 80,000 separate cells. What I want to do could is something like the next expression which is not permitted: =SUM(IF(COUNTIF(I1:L1,"*Word*")1,1,COUNTIF(I1:L1, "*Word*")): IF(COUNTIF(I10000:L10000,"*Word*")1,1,COUNTIF(I10 000:L10000,"*Word*"))). Can you please give me a good piece of advice? Thank you in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
summation | Excel Worksheet Functions | |||
conditional summation | Excel Discussion (Misc queries) | |||
Summation Operator | Excel Worksheet Functions | |||
Summation and Lookup | Excel Discussion (Misc queries) | |||
Summation from a to b | Excel Worksheet Functions |