Hellp Me Excel Help!!!!
I have been helped so many times on this site that its good to give it back
for someone else
Best
Stew
"headbanging_Fe" wrote:
awww stew thank you so much. do you know long i have been trying to that for!
so the prices only now relate the letter it is in the bracket to.
Thank You
"stew" wrote:
Try this
=(COUNTIF(G12:K12,"D")*34)+(COUNTIF(G12:K12,"M")*2 0)+(COUNTIF(G12:K12,"A")*15)
Best
Stew
"headbanging_Fe" wrote:
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
|