Forum Discussion
VLOOKUP, ARRAY, ROW, COLUMN please help!!!
I need a formula that will search the item # from table 1 in table 2 and display the number for each individual category ("inca", "ineb", etc.) The lines that do not have sales I want it to display a...
Hi Karla Ruelas,
A SUMIFS formula should solve your problem without the potential #N/A issue from a VLOOOKUP
I've assumed your Pivot Table is on a sheet called Sheet2
=IF( I2="No","", SUMIFS( Sheet2!$B:$B, Sheet2!A:A, $A2) )