OK, I see what you mean.

=(COUNTIF(G12:K12,"D")*34)+(COUNTIF(G12:K12,"M")*2 0)+(COUNTIF(G12:K12,"A")*15)

=SUM(COUNTIF(G12:K12,{"D","M","A"})*{34,20,15})

Yes, both of those formulas do the exact same thing.

--
Biff
Microsoft Excel MVP


"headbanging_Fe" wrote in message
...
sorry i thought you could see what someone else had wrote as a formula.

"T. Valko" wrote:

would this do the same.

Do the same as what?

?????


--
Biff
Microsoft Excel MVP


"headbanging_Fe" wrote in
message
...
would this do the same.

"T. Valko" wrote:

Try this:

=SUM(COUNTIF(G12:K12,{"D","M","A"})*{34,20,15})

--
Biff
Microsoft Excel MVP


"headbanging_Fe" wrote in
message
...
i use "D" for day, "M" for morning, "A" afternoon.
this is the formula: =COUNTIF(G12:K12, "D")+COUNTIF(G12:K12,
"M")+COUNTIF(G12:K12,"A")

if i have a child the attends 5 full days the it should work out
that
price.
if a child atttends a morning afternoon and all day then the formula
is
should work out the different prices for all. so "M" is £20, "D" is
£34
and
"A" is £15

"T. Valko" wrote:

You'll need to tell us how you identify a session as Morning,
Afternoon
or
All Day.

--
Biff
Microsoft Excel MVP


"headbanging_Fe" wrote
in
message
...
ok, i have used a countif formula to work out how many days are
accounted
for!.
now i want to create another formula where it adds up the days as
well
as
adds the price of the day to it.
i have tried an if statement and countifs. but i dont no wot
formula
i
need
to be able to do this.

the low down... im creating a spreadsheet data base for a
nursery.
and
there
are 3 sessions Morning, Afternoon and all day. i did a countif
formula
to
work out the days attentended. now each session has a different
rate
all
day
being 34, morning £20 and afternoon £15. now i was to link the
countif
formula to these prices.

Thank you