Posted to microsoft.public.excel.worksheet.functions

ann

external usenet poster

Posts: 210

sumif or countif not sure

i want to sum the numbers in column B based on the criteria in column A and
give a count. not sure what the combo is.

Col A col b
1 9.99
1 9.99
2 10.00
2 30.00

so i want the result to show
1 19.98
2 40.00

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/COUNTIF	Tatebana	Excel Discussion (Misc queries)	3	February 16th 07 01:50 PM
CountIF or SumIF	Scott@CW	Excel Discussion (Misc queries)	3	December 15th 06 12:54 PM
Countif/Sumif	Cain	Excel Worksheet Functions	2	February 12th 06 07:59 PM
COUNTIF or SUMIF or ??	croakingtoad	Excel Worksheet Functions	2	November 28th 05 03:05 PM
Countif, Sumif, If - help!	Angel160	Excel Worksheet Functions	2	November 3rd 04 05:23 PM

All times are GMT +1. The time now is 03:05 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us