Hi there. This formula I entered in cell A2 does not work …. =SUMIF(A3:A12,"X",A1)
A1 contains $500
I want to display $500 in A2, if the range of A3:A12 contains an X anywhere in that range.
Help please?
Hi there. This formula I entered in cell A2 does not work …. =SUMIF(A3:A12,"X",A1)
A1 contains $500
I want to display $500 in A2, if the range of A3:A12 contains an X anywhere in that range.
Help please?
You could use something like:
Formula:Please Login or Register to view this content.
or
Formula:Please Login or Register to view this content.
The first will show a 0 if 'X' is not found in the range, while the second will show nothing ("").
Thank you so much!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks