Totalling selected cells

**Cabbie** · 02-05-2012, 12:32 AM

I use Excel to record my daily takings from my taxi.

I manually add a formula to total each weeks takings and bold the entry to make it easier for me to refer to.

I'd like help with a formula to add each of the bold entries only so that I can get quarterly totals which I can extract for my BAS statement.

Thanks in anticipation.

**dilipandey** · 02-05-2012, 01:09 AM

Hi Cabbie,

Welcome to the forum.

You can use sumif function which would sum the entries against which you have "Total" written.
If this is not clear, post a sample file. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**Cabbie** · 02-05-2012, 01:40 AM

Thank you
How do I post a sample file??

**dilipandey** · 02-05-2012, 02:11 AM

Click on "go advanced" while replying to this post and then look for paper clip icon to upload a sample file. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**pmalen** · 02-05-2012, 10:33 AM

Try this. As you can see, as you track the data, you could develop reports that show bookings by day to see what the good days are vs slow days. If this was helpful, please click on the star below the thread.

Thanks

Paul