Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with count/sumif
Hi,
I am creating a spreadsheet that calculates scorings for nursery figures. so, IF column A = M, then count how many in Column B = A. This is probably really simple, but I am sure you guys can help! Thanks Jooniper :) |
#2
|
|||
|
|||
Quote:
=SUMPRODUCT(('Data Sheet 1'!$E$12:$E$249="M")*('Data Sheet 1'!J12:J249="B")) Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with count/sumif
Hi,
Am Thu, 30 Aug 2012 10:37:01 +0000 schrieb Jooniper: I am creating a spreadsheet that calculates scorings for nursery figures. so, IF column A = M, then count how many in Column B = A. This is probably really simple, but I am sure you guys can help! =SUMPRODUCT(--(A1:A100="M"),--(B1:B100="A")) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF using two criteria to count | Excel Worksheet Functions | |||
Count or Sumif formula | Excel Discussion (Misc queries) | |||
Count, Countif, Sumif?? | Excel Worksheet Functions | |||
sumif or count between zero and 3 | Excel Worksheet Functions | |||
sumif or count between zero and 3 | Excel Worksheet Functions |