Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Numbers 09 - I need an experienced formul-ologist:

So I have a spreadsheet.

So I have the days of the week and amount, example:

MON +500

TUES +89

etc..

The weeks go on and on. THEN, I have a small table (we'll call it table X) that lists the days of the week and the total amount overall.

Is there a way that I can set up table X so that once I type in "MON +500". Table X automatically adds +500 to Monday. Basically searching for all "Mondays" and adding that amount together.

THANKS!

Posted on Apr 7, 2014 12:34 AM

Reply
Question marked as Best reply

Posted on Apr 7, 2014 5:16 AM

Hi Oducks,


If I understand what you want, the SUMIF function will do it.


Table 1 has a list of dates in Column A. Column B uses DAYNAME to pull the day of the week from A. A2 contains this formula (and Fill Down):


=DAYNAME(A2)


Column C is where you enter the amount for that date.


User uploaded file


The small summary table (I have called it Totals per Weekday) uses SUMIF


User uploaded file

B2 contains this formula (and Fill Down):


=SUMIF(Table 1::B,A2,Table 1::C)


It looks in Table 1 Column B for weekdays that match, then sums those cells from C in Table 1. For example, B2 sums Table 1, Column C where the rows contain Monday in Column B.


Regards,

Ian.

3 replies
Question marked as Best reply

Apr 7, 2014 5:16 AM in response to Oducks

Hi Oducks,


If I understand what you want, the SUMIF function will do it.


Table 1 has a list of dates in Column A. Column B uses DAYNAME to pull the day of the week from A. A2 contains this formula (and Fill Down):


=DAYNAME(A2)


Column C is where you enter the amount for that date.


User uploaded file


The small summary table (I have called it Totals per Weekday) uses SUMIF


User uploaded file

B2 contains this formula (and Fill Down):


=SUMIF(Table 1::B,A2,Table 1::C)


It looks in Table 1 Column B for weekdays that match, then sums those cells from C in Table 1. For example, B2 sums Table 1, Column C where the rows contain Monday in Column B.


Regards,

Ian.

Numbers 09 - I need an experienced formul-ologist:

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.