Sumif using isdate

[Sc0tt1e]

Is it possible to use the isdate function in a sumif?

Looking to sum column B if column a has a date in it (when an invoice is paid. Can't get it working myself so looking for some guidance as google isn't helping me right now

[sweep]

Hi,

What else do you have in column A, apart from the dates?

[MRUTOR]

Hello,

a sample workbook with some dummy data and which data should by sum would be helpful

[Limor_OP]

If you have only dates/text then you can apply this:

=SUM(IF(ISNUMBER(DATES_RANGE)=TRUE,SUM_RANGE))

[Croweater]

Try something like;

Please Login or Register  to view this content.

[davsth]

Belinda did not say that this is an array formula and needs to be entered with shift control enter

sumproduct((ISNUMBER(DATES_RANGE))*(SUM_RANGE)) is a non array answer

but neither will exclude a number in the range that isn't a date

[Sc0tt1e]

it's going to be blank, a date or maybe - if there was no invoice

[Sc0tt1e]

If you have only dates/text then you can apply this:

=SUM(IF(ISNUMBER(DATES_RANGE)=TRUE,SUM_RANGE))

That didn't work, no wait that worked as an array. Cheers

[Limor_OP]

Please look at the attached:

D3 =SUM(IF(ISNUMBER(A1:A3)=TRUE,B1:B3))

[Limor_OP]

Dvash is right, it is an array formula.
In order to produce the result - you need to press Ctrl+Shift+Enter (press and hold Ctrl, press and hold Shift, then press Enter and let go of all three). After we finish entering the formula with Ctrl+Shift+Enter, the formula will be surrounded by curly braces {=…}

[Croweater]

Belinda did not say that this is an array formula and needs to be entered with shift control enter

sumproduct((ISNUMBER(DATES_RANGE))*(SUM_RANGE)) is a non array answer

but neither will exclude a number in the range that isn't a date

I beg to Differ. The SUMIF works OK with a number or text or a blank for that matter.

[davsth]

Croweater you are correct the sumif function is not an array formula

However Belinda provided SUM(IF(ISNUMBER(A1:A3)=TRUE,B1:B3)) which is an array formula, not a sumif in sight!

[Limor_OP]

Davsh - now I see that my formula works without the CSE. could this be?

[davsth]

its solved so not to worry ! it would work for the first line, does it work for the second, often arrays without being entered look at the first line so

SUM(IF(ISNUMBER(A1)=TRUE,B1))

but it works so I am not really bothered!

[Limor_OP]

OK, thank you