Text version of formula

[sturae]

I Have Been Asked To Enter The Text Version Of The Formulas Below. Using No Equals Or $ Signs. Can Anyone Help???

=subtotal (9,b17:b29)

=subtotal (1,d15:d25)

[ScottO]

By "Text Version" do you mean "describe what the formula is doing in
English", or do you mean something else?
Rgds,
ScottO

"sturae" <sturae.20tlna_1135891201.1071@excelforum-nospam.com> wrote
in message
news:sturae.20tlna_1135891201.1071@excelforum-nospam.com...
|
| I Have Been Asked To Enter The Text Version Of The Formulas Below.
Using
| No Equals Or $ Signs. Can Anyone Help???
|
| =subtotal (9,b17:b29)
|
| =subtotal (1,d15:d25)
|
|
| --
| sturae
| -------------------------------------------------------------------
-----
| sturae's Profile:
http://www.excelforum.com/member.php...o&userid=29984
| View this thread:
http://www.excelforum.com/showthread...hreadid=496793
|

[sturae]

This is the question asked:


USE DATA FILTERING AND APPROPRIATE SUBTOTAL FUNCTIONS TO CALCULATE
THE FOLLOWING AMOUNTS.
NOTE: YOU MUST TYPE YOUR ANSWERS IN TO THE YELLOW HIGHLIGHTED AREAS AFTER
YOU HAVE WRITTEN THE FORMULAE AND PERFORMED THE FILTER ELSEWHERE
IN THE SHEET. DO NOT ENTER FORMULAE TO THE YELLOW AREAS - ANSWERS ONLY.

THE AVERAGE PRICE OF ALL SHARES WITH A DIVIDEND OF MORE THAN £0.20
THAT WERE NOT UK OWNED. ANSWER TO G8. 1.95
ENTER THE TEXT VERSION OF THE FORMULA USED TO G9 (NO EQUALS OR $ SIGNS).
THE TOTAL DIVIDEND ON ALL SHARES WITH A PRICE OF LESS THAN £2.50
THAT WERE PURCHASED BEFORE 1994. ANSWER TO G11 0.85
ENTER THE TEXT VERSION OF THE FORMULA USED TO G12 (NO EQUALS OR $ SIGNS)

Share name Price (£) No. held Dividend (£) Purchase Year UK owned = 1
Agricola 0.65 1 0.12 1990 1
Cathedral Life 2.43 1 0.34 1990 1
Commercial Plus 1.67 1 0.21 1989 0
MBI 0.99 1 0.18 1990 1