Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding multiple cells together
I'm trying to think of a formula to compare two cells together once they
match I need to count how many times another cell has an entry in it. Any ideas?? For example one sheet has initials, and the other sheet has those initials in it. Once it sees those initials it will count how many times that other cell has an "X" in it. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding multiple cells together
Try using the following formula.
=IF(Sheet1!A1:A3=Sheet2!A1,COUNTIF(Sheet1!B1:B3,"x "),"") Be sure to enter the correct sheet name and range. "ignitedaz" wrote: I'm trying to think of a formula to compare two cells together once they match I need to count how many times another cell has an entry in it. Any ideas?? For example one sheet has initials, and the other sheet has those initials in it. Once it sees those initials it will count how many times that other cell has an "X" in it. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding multiple cells together
Thanks for the advice but for some reason it is adding all of the entries in
only one cell. Here is the formula I used; =IF(GG!$B$2:$B$250='INDIVIDUAL TOTAL'!$A5,COUNTIF(GG!$L$2:$L$250,"X"),"") It seems to ignore the lookup for the initials which lie in B2:B250 and A5... please help "Gilbert" wrote: Try using the following formula. =IF(Sheet1!A1:A3=Sheet2!A1,COUNTIF(Sheet1!B1:B3,"x "),"") Be sure to enter the correct sheet name and range. "ignitedaz" wrote: I'm trying to think of a formula to compare two cells together once they match I need to count how many times another cell has an entry in it. Any ideas?? For example one sheet has initials, and the other sheet has those initials in it. Once it sees those initials it will count how many times that other cell has an "X" in it. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding multiple cells together
Try removing the $ from 'INDIVIDUAL TOTAL '!$A5 just leave it as !A5.
"ignitedaz" wrote: Thanks for the advice but for some reason it is adding all of the entries in only one cell. Here is the formula I used; =IF(GG!$B$2:$B$250='INDIVIDUAL TOTAL'!$A5,COUNTIF(GG!$L$2:$L$250,"X"),"") It seems to ignore the lookup for the initials which lie in B2:B250 and A5... please help "Gilbert" wrote: Try using the following formula. =IF(Sheet1!A1:A3=Sheet2!A1,COUNTIF(Sheet1!B1:B3,"x "),"") Be sure to enter the correct sheet name and range. "ignitedaz" wrote: I'm trying to think of a formula to compare two cells together once they match I need to count how many times another cell has an entry in it. Any ideas?? For example one sheet has initials, and the other sheet has those initials in it. Once it sees those initials it will count how many times that other cell has an "X" in it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding up data in multiple cells for a single criteria. | Excel Worksheet Functions | |||
link multiple cells to multiple cells | Excel Discussion (Misc queries) | |||
link multiple cells to multiple cells | Excel Discussion (Misc queries) | |||
Formula to delete blank cells across multiple columns? | Excel Worksheet Functions | |||
Adding separate accumulators for multiple cells | New Users to Excel |