Hi,
I'm an Excel newbie and in a bit of a pickle.
I'm trying to find the sum of a range of cells (A1:C12) for numbers between 20 to 80, but only ones that are even numbers.
I'd normally do this with a SUMIFS function easily, but I have no idea how to narrow it down to just the even numbers. I'd wager with a MOD function, but I don't know how to *ahem* formulate my formula
Any tips?
Thanks in advance!
I'm an Excel newbie and in a bit of a pickle.
I'm trying to find the sum of a range of cells (A1:C12) for numbers between 20 to 80, but only ones that are even numbers.
I'd normally do this with a SUMIFS function easily, but I have no idea how to narrow it down to just the even numbers. I'd wager with a MOD function, but I don't know how to *ahem* formulate my formula

Any tips?
Thanks in advance!