Hello all,
I've recently created a spreadsheet to keep track of our daily menu.
The spreadsheet involves a day-by-day calender sort of blocking with
slots for breakfast, lunch, and dinner.

What I do is enter in the items we need for that meal (ie. pancakes,
burritos, etc, in B1), my formula then takes that text and fills in the
field to the right (let's assume B2) with the amount of servings in each
case of that item. In field B3 the servings for that day are divided by
the servings/case (B2) and it gives me the amount of that item (in
cases) that I'll need for that day with that many people to serve.

Currently, I'm going through the spreadsheet and finding each instances
of "pancake", then including that in a SUM function which includes all
the fields which deal with pancakes usage.

What I would like to be able to do, is sum up the amount of cases I'll
need (B3), but with the criteria of B1.

By way of example, I'll have a section at the bottom of my worksheet
that will list all of my inventory. Next to each field which includes
the item will be how much of that item will be used that week. This
number will be arrived at by some sort of sumif that will go through
the spreadsheet, find each instance of "pancake", then add up all of
the fields 2 fields to the right of the field filled with "pancake."

I tried using a SumIf, but that is only usable with ranges and it
doesn't quite fit my needs. Is there any function I could use, or
make, that would fulfill my needs?

Thanks.


--
NickDucote
------------------------------------------------------------------------
NickDucote's Profile: http://www.excelforum.com/member.php...o&userid=30290
View this thread: http://www.excelforum.com/showthread...hreadid=499579

It does sound to me that you want SUMIF

=SUMIF(B1:B100,"Pancakes",D1:D100)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"NickDucote" wrote
in message ...

Hello all,
I've recently created a spreadsheet to keep track of our daily menu.
The spreadsheet involves a day-by-day calender sort of blocking with
slots for breakfast, lunch, and dinner.

What I do is enter in the items we need for that meal (ie. pancakes,
burritos, etc, in B1), my formula then takes that text and fills in the
field to the right (let's assume B2) with the amount of servings in each
case of that item. In field B3 the servings for that day are divided by
the servings/case (B2) and it gives me the amount of that item (in
cases) that I'll need for that day with that many people to serve.

Currently, I'm going through the spreadsheet and finding each instances
of "pancake", then including that in a SUM function which includes all
the fields which deal with pancakes usage.

What I would like to be able to do, is sum up the amount of cases I'll
need (B3), but with the criteria of B1.

By way of example, I'll have a section at the bottom of my worksheet
that will list all of my inventory. Next to each field which includes
the item will be how much of that item will be used that week. This
number will be arrived at by some sort of sumif that will go through
the spreadsheet, find each instance of "pancake", then add up all of
the fields 2 fields to the right of the field filled with "pancake."

I tried using a SumIf, but that is only usable with ranges and it
doesn't quite fit my needs. Is there any function I could use, or
make, that would fulfill my needs?

Thanks.


--
NickDucote
------------------------------------------------------------------------
NickDucote's Profile:
http://www.excelforum.com/member.php...o&userid=30290
View this thread: http://www.excelforum.com/showthread...hreadid=499579

However, I want this sumif to apply to multiple B1's and D1's.


--
NickDucote
------------------------------------------------------------------------
NickDucote's Profile: http://www.excelforum.com/member.php...o&userid=30290
View this thread: http://www.excelforum.com/showthread...hreadid=499579

It does.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"NickDucote" wrote
in message ...

However, I want this sumif to apply to multiple B1's and D1's.


--
NickDucote
------------------------------------------------------------------------
NickDucote's Profile:
http://www.excelforum.com/member.php...o&userid=30290
View this thread: http://www.excelforum.com/showthread...hreadid=499579