Posted to microsoft.public.excel.programming

pantelis

external usenet poster

Posts: 27

Sumif for countif?

Hi all,

Got a bit of a problem, I want to use the sumif comand as a countif i.e. I
have data with years 1990 to 2003 in column A and in column B I have various
numbers.

I want with a comand similar to sumif to show show me how many of the 1990
years make up the 1990 total.

Would appreciate your help.

Pantelis

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 And Countif	roter789	Excel Worksheet Functions	7	August 21st 09 12:00 AM
Sumif / Countif	Blue	Excel Worksheet Functions	3	May 15th 09 03:50 PM
COUNTIF?? SUMIF??	Vegs	Excel Discussion (Misc queries)	1	December 19th 05 03:52 PM
COUNTIF or SUMIF or ??	croakingtoad	Excel Worksheet Functions	2	November 28th 05 03:05 PM
Countif and sumif	Visual	Excel Discussion (Misc queries)	19	August 10th 05 05:59 PM

All times are GMT +1. The time now is 04:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us