Is it possible to use SUMIF to allow multiple conditions? i.e. SUMIF based on criteria of >=800000 and <900000.
I have a feeling it'll be a sumproduct, right?
edit: ok it's sumproduct by the looks of it![]()
Is it possible to use SUMIF to allow multiple conditions? i.e. SUMIF based on criteria of >=800000 and <900000.
I have a feeling it'll be a sumproduct, right?
edit: ok it's sumproduct by the looks of it![]()
You can also use the sum(if function
![]()
=SUM(IF((A7:A9>=800000)*(A7:A9<900000),A7:A9))
oh nice, that looks somewhat neater.
Learn something new every day![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks