Adding up a column in a worksheet

  • Thread starter Thread starter Joseph
  • Start date Start date
J

Joseph

I'm having trouble figuring how to add up a column that meet a condition in
Sheet1 and having the results show in Sheet 2.

Example of what I'm trying to do:

Month Amount Category
Jan 523.00 JOB1
Jan 121.00 JOB2
Jan 75.00 JOB1

Any assistance would be greatly appreciated,
Thanks,
 
Maybe something like this:

Sum of Job1 for Jan:

=SUMPRODUCT(--(Sheet1!A1:A100="Jan"),--(Sheet1!C1:C100="Job1"),Sheet1!B1:B100)
 
You don't say what the conditions are but assuning that they are *Jan* in
Column A, *JOB1* in Column C and the amount in Column B try:

=SUMPRODUCT((Sheet1!A2:A20="Jan")*(Sheet1!C2:C20="JOB1")*Sheet1!B2:B20)

If the *Jan* is a date formatted as mmm then use:

=SUMPRODUCT((Sheet1!A2:A20<>"")*(MONTH(Sheet1!A2:A20)=1)*(Sheet1!C2:C20="JOB1")*Sheet1!B2:B20)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Thank you Sandy..

Sandy Mann said:
You don't say what the conditions are but assuning that they are *Jan* in
Column A, *JOB1* in Column C and the amount in Column B try:

=SUMPRODUCT((Sheet1!A2:A20="Jan")*(Sheet1!C2:C20="JOB1")*Sheet1!B2:B20)

If the *Jan* is a date formatted as mmm then use:

=SUMPRODUCT((Sheet1!A2:A20<>"")*(MONTH(Sheet1!A2:A20)=1)*(Sheet1!C2:C20="JOB1")*Sheet1!B2:B20)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
Click to expand...
 
Back
Top