## MAXIFS function

Excel » Functions » Statistical » MAXIFS function »

How to use the MAXIFS function

The MAXIFS function returns the largest number based on a condition or criteria. The MAXIFS function was introduced in Excel […]

Find and return the highest number and corresponding date based on a condition

This article describes how to filter records based on the maximum value of a specific item. There are names in […]

Get the smallest number larger than a given number

This article demonstrates how to extract the smallest number larger than a condition and the largest number smaller than a […]

Find latest date based on a condition

This article demonstrates how to return the latest date based on a condition using formulas or a Pivot Table. The […]

Lookup min max values within a date range

This article explains how to find the smallest and largest value using two conditions. In this case they are date […]
{"ft_lang_label":"__label__en","ft_lang_prob":0.78453416,"math_prob":0.9226276,"size":915,"snap":"2022-05-2022-21","text_gpt3_token_len":179,"char_repetition_ratio":0.14489572,"word_repetition_ratio":0.09677419,"special_character_ratio":0.19781421,"punctuation_ratio":0.025974026,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.9812118,"pos_list":[0],"im_url_duplicate_count":[null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2022-05-18T00:46:38Z\",\"WARC-Record-ID\":\"<urn:uuid:fc46c26e-3a82-4671-887b-a74947c32d4b>\",\"Content-Length\":\"61421\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:430b1974-262e-404f-9ba8-6340fd126c96>\",\"WARC-Concurrent-To\":\"<urn:uuid:81a91ab6-183d-41e3-bdff-d5f02d7077cd>\",\"WARC-IP-Address\":\"104.26.8.201\",\"WARC-Target-URI\":\"https://www.get-digital-help.com/category/excel/functions/statistical/maxifs/\",\"WARC-Payload-Digest\":\"sha1:JIMOMH7HHCBQJB4EJSZ2LBHIP4OHHVUN\",\"WARC-Block-Digest\":\"sha1:6TNAMHPK4YPCUO7UJOZEV7XQ3N6TR423\",\"WARC-Identified-Payload-Type\":\"application/xhtml+xml\",\"warc_filename\":\"/cc_download/warc_2022/CC-MAIN-2022-21/CC-MAIN-2022-21_segments_1652662520936.24_warc_CC-MAIN-20220517225809-20220518015809-00596.warc.gz\"}"}