LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 5th 17, 04:39 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
First recorded activity by ExcelBanter: May 2017
Posts: 2
Default Inverse of COUNTIF??

Hi Jason,

I'd like to know what formula should i use if i have to copy the text or value from 1 sheet to another with this specific date.

  #2   Report Post  
Old June 23rd 21, 04:27 PM
First recorded activity by ExcelBanter: Jun 2021
Posts: 47
Default INVERSE of Countif?

Hello, I'm not so sure if I understood your question, but, to do an inverse of your countif, meaning counting the numbers you didn't want to include in your countif function, you can use this formula:

=COunt(A1:A10) - Countif(A1:A10, criteria)

There you can count the remaining items you didn't want to include in your countif. You can also check for more info on countif.

Hope this helps!

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Inverse FFT shull Excel Programming 2 June 5th 09 09:15 AM
TAN INVERSE ? Ahsan Excel Worksheet Functions 3 June 19th 07 04:09 PM
how do i calculate inverse tan? Emma Excel Worksheet Functions 5 October 5th 06 03:36 PM
log inverse Az Excel Discussion (Misc queries) 1 November 28th 05 09:12 AM
Inverse sin John Fitzpatrick Excel Worksheet Functions 3 March 25th 05 06:35 PM

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

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017