I am trying to create three different values based on the same data and need
to break out totals by criteria on one tab with the forumulas and datasets on
other tabs. I have the sum for all values correct doing a Vlookup formula
that will return a blank value instead of #N/A :
=IF(ISNA(VLOOKUP($A18,Jan!$M$3:$S$25,7,0)),0,VLOOK UP($A18,Jan!$M$3:$S$25,7,0))

Now how do I add on conditions to get the sum of the products I want instead
of the totals, example how many cars were sold from a dealer, how many trucks
and how man vans? I know how many vehicles, but now need to break it down by
criteria on the monthly sales tab in the column next to the sales totals.

Any help is appreciated.