Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training courses - SUMIF - Two Variables
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel training courses - SUMIF - Two Variables
Resolved · Low Priority · Version Standard
Reply Fri 28 Sep 2007, 15:24Delegate Heather said...
Heather has attended:
Excel Intermediate course
Excel Advanced course
Outlook Advanced course
Powerpoint Intermediate Advanced course
Word Advanced course
SUMIF - Two Variables
how do i use the SUMIF function for two variables. i.e. i want to sum the values of products that were purchased between march and april AND were blue.
For upcoming training course dates see: Pricing & availability
Reply Fri 28 Sep 2007, 16:00Delegate Paul said...
RE: SUMIF - Two Variables
Hi Heather,
I don't know what the trainers would do, but I'd use 2 columns to sort this out, then hide them to keep my spreadsheet tidy
let's say for example your dates purchased are in column D and your colours are in column E.
In row 1 of column G type this:
=IF(AND(D1>=39142,D1<=39202),1,0)
this will return a 1 if the date in cell Dx is between March 1st and April 30th
then in row 1 of column H, type this:
=IF(AND(E1="blue",G1=1),1,0)
this will return a 1 if cell Gx = 1 and if cell Ex = blue
then you can sum up column H and you have the total number of "blue" bought in March & April
|