No no no, this will add ALL the visible values up.
Position - Word - Value
3 - Hot- 45
5 - Hot - 23
5 - Hot - 32
7 - Hot - 44
2 - Hot - 22
Ok, now in this example, I'd only want to calculate the value of HOT
when it was in 5th position.
I need an IF statement somewhere.
SumIf would include the invisible cells as well wouldn't it?
I need something like
Add totals for the word HOT (or whichever word I've filtered out to) in
position 5.
--
muchacho
------------------------------------------------------------------------
muchacho's Profile:
http://www.excelforum.com/member.php...o&userid=35082
View this thread:
http://www.excelforum.com/showthread...hreadid=555662