SSHO_99

Posts: n/a

Modify SUMIF and COUNTIF to work with SUBTOTALS

I use SUMIF and COUNTIF formula's to sum and count data within specific
ranges. Here are the formula's I use to find data from 5.0 to 15.0:

=SUM(N2:N220,-SUMIF(N2:N220,{"<=5.0","=15.0"}))

=COUNTIF(N2:N220,"=5.0")-COUNTIF(N2:N220,"=15.0")

Is there a way to modify these formula's to work with SUBTOTALS?

Thanks,

Steve

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
How do I create a formula in Excel that will countif or sumif bef.	bkclark	Excel Worksheet Functions	4	November 10th 04 05:30 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 05:01 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us