Hi Hylton,
You can transform your fomula in C3 of your Summary sheet like this:
=SUMIFS(Data.C$3:Data.C$1000,Data.$A$3:Data.$A$1000,CONCATENATE("=",$A3
,"*"),Data.$F$3:Data.$F$1000,CONCATENATE("<>","Y"))
This formula will add the values in the data column, provided the RECON
is not "Y" (which is
Hi Hylton.
There is an ISBLANK() function that will test if the cell is blank.
Safer might be to test IF UPPER($Data.F$3:F$1000) NOT "Y"
Check the help on SUMFS also for multiple test criteria as you could
test for ISBLANK(), is not "y", is not "Y"
Is there a reason you are not entering the
Hi,
I have a spreadsheet of two tabs with tab 1 named 'Data' and the other
named 'Summary'. The purpose of this spreadsheet group is to record all
credit card account transactions on the 'Data' sheet and then see what
value or transaction slips have not bee submitted by suppliers i.e. the
