I want to sum up the numbers in column J conditionally if BOTH of 2 separate conditions are met.This formula works ; to wit,SUMIF(b2:b99,>1,j2:j99)But how should one put in "and" so that it also includes f2:f99, >3 , j2:j99The sumnation would then be of fewer cells than either condition on its own; and the count would also be fewer.I use windows 98.
this is a duplicate. I am sorry.please erase.
This thread is now locked and can not be replied to.
Galaxy Note 8 vs iPhone X
Awful clip art from 1994 is being tweeted every hour by a bot
iPhone X vs Samsung Galaxy Note 8
Les meilleurs navigateurs internet 2017
© Copyright 2017 IDG UK. All Rights Reserved.