Posted to microsoft.public.excel.worksheet.functions

Teethless mama Teethless mama is offline

external usenet poster

Posts: 3,718

countifs/or

=SUM(COUNTIFS(A:A,"<",C:C,"",D:D,{"Received","n/a"}))

"Caroline" wrote:

I have the following formula in a spreadsheet:
=COUNTIFS(A:A,"<",C:C,"",D:D,"Received")
I now want to also count rows in column D that have "n/a" (I want to count
both "n/a" and "received".
How do I modify the function to include those?
Thank you,
Caroline

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
Countifs	Carl	Excel Worksheet Functions	1	April 22nd 09 04:28 PM
Countifs	CD27	Excel Worksheet Functions	2	April 21st 09 06:36 PM
CountIfs	vreeckes	Excel Worksheet Functions	4	February 19th 09 02:57 AM
Countifs to Sumproduct for 2003 - was Simple Countifs.. from Fr	Steve	Excel Worksheet Functions	2	January 4th 09 05:36 PM
countifs	Forza MIlan	Excel Discussion (Misc queries)	2	July 4th 07 09:48 AM

All times are GMT +1. The time now is 11:52 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us