Posted to microsoft.public.excel.worksheet.functions

Claus Busch Claus Busch is offline

external usenet poster

Posts: 3,872

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 With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SUMIF using two criteria to count	mokihi	Excel Worksheet Functions	2	May 21st 09 04:49 AM
Count or Sumif formula	Jeremy	Excel Discussion (Misc queries)	2	June 10th 08 03:51 PM
Count, Countif, Sumif??	benjam_in	Excel Worksheet Functions	6	July 12th 06 06:29 PM
sumif or count between zero and 3	tomr	Excel Worksheet Functions	0	March 26th 06 11:57 PM
sumif or count between zero and 3	Franksta	Excel Worksheet Functions	0	March 26th 06 11:46 PM

All times are GMT +1. The time now is 06:38 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us