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