Home |
Search |
Today's Posts |
#1
|
|||
|
|||
NOt sure if COUNTIF is the right function here...?
Help! I have a formula that currently reads COUNTIF('SheetOne'D$3:D$1506,A2). The next row is COUNTIF('SheetOne'D$3:D$1506,A2) +COUNTIF ('SheetOne'D$3:D$1506,A2). The formula works perfectly but unfortunately I need to go all the way down to A1517 adding an extra row each time.... Is there another way round this to get the same result but save me entering this 1517 times?!?
Thank you so much if you can help me! |
#2
|
|||
|
|||
Quote:
__________________
Asobi Wa Owari Da |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
countif function | Excel Worksheet Functions | |||
please help how to combine IF function with Countif function | Excel Worksheet Functions | |||
How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
Embed a countif function in subtotal function? | Excel Worksheet Functions | |||
CountIf Function Help | Excel Discussion (Misc queries) |