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![Wink ;) ;)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f609.png)
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
![Wink ;) ;)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f609.png)
Any tips?
Thanks in advance!